| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Fixing PKs and Uniques in tablespaces |
| Date: | 2004-07-22 07:54:46 |
| Message-ID: | 40FF72C6.5040807@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>>Since we stole tablespaces from Oracle, maybe we should make them work
>>the same?
>
> I never really considered oracle's implementation of tablespaces when I
> worked on tablespaces. The database default tablespace seems similar to
> Oracle's SYSTEM tablespace. I'm not sure if they use a global tablespace
> like we do.
My point was that Oracle has added a tablespace clause to the constraint
clause, so we can too!
Also, since I checked and it seems that our syntax for putting tables an
d indexes in tablespaces at creation time is identical to oracle's,
perhaps we should copy them on constraints as well.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-07-22 10:11:29 | Re: [pgsql-hackers-win32] Weird new time zone |
| Previous Message | Gavin Sherry | 2004-07-22 07:47:26 | Re: Fixing PKs and Uniques in tablespaces |