Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-23 Thread Gaetano Mendola
Christopher Kings-Lynne wrote: 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

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-23 Thread Christopher Kings-Lynne
We are already in a features freeze period, or not ? This isn't a feature, it's a bug... Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-23 Thread Zeugswetter Andreas SB SD
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. Since we're getting close to beta, can we have consensus on what I'm to do about this? The

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-23 Thread Peter Eisentraut
Christopher Kings-Lynne wrote: 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. Since we're getting close to beta, can we have consensus on what

[HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Christopher Kings-Lynne
Does anyone object to extending the grammar to allow this? ALTER TABLE test ADD PRIMARY KEY (a) TABLESPACE foo; ALTER TABLE test ADD UNIQUE (a) TABLESPACE foo; CREATE TABLE test (a INTEGER PRIMARY KEY TABLESPACE foo); CREATE TABLE test (a INTEGER UNIQUE TABLESPACE foo); This is needed since we can

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Does anyone object to extending the grammar to allow this? Yes. This is horribly ugly, and I suspect that you cannot do it without making TABLESPACE a fully-reserved word. regards, tom lane

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Christopher Kings-Lynne
Yes. This is horribly ugly, and I suspect that you cannot do it without making TABLESPACE a fully-reserved word. No, I've already done it and it works just fine. What is your suggestion then? Just assume the name of the index it will get? Also, I realised that the pg_get_serial_sequence()

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Christopher Kings-Lynne
Does anyone object to extending the grammar to allow this? Yes. This is horribly ugly, and I suspect that you cannot do it without making TABLESPACE a fully-reserved word. I note that this seems to be the Oracle syntax: CONSTRAINT PK_Stock PRIMARY KEY (Company) USING INDEX TABLESPACE

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Christopher Kings-Lynne
Does anyone object to extending the grammar to allow this? Yes. This is horribly ugly, and I suspect that you cannot do it without making TABLESPACE a fully-reserved word. This suggests a slightly different oracle syntax. I guess the word 'index' is optional.

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Christopher Kings-Lynne
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

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Gavin Sherry
On Thu, 22 Jul 2004, Christopher Kings-Lynne wrote: Does anyone object to extending the grammar to allow this? Yes. This is horribly ugly, and I suspect that you cannot do it without making TABLESPACE a fully-reserved word. I note that this seems to be the Oracle syntax: CONSTRAINT

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

2004-07-22 Thread Christopher Kings-Lynne
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