Re: Fixing PKs and Uniques in tablespaces - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Fixing PKs and Uniques in tablespaces
Date
Msg-id 40FF6D88.3050206@familyhealth.com.au
Whole thread Raw
In response to Re: Fixing PKs and Uniques in tablespaces  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fixing PKs and Uniques in tablespaces
List pgsql-hackers
>>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 
Appl_Indexes

http://www.siue.edu/~dbock/cmis564/otext4.htm

Since we stole tablespaces from Oracle, maybe we should make them work 
the same?

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Fixing PKs and Uniques in tablespaces
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Fixing PKs and Uniques in tablespaces