Re: Undocumented feature? USING INDEX TABLESPACE

[Elliot <yields.falsehood@xxxxxxxxx>]

On 2013-10-30 06:32, Tim Kane wrote:

Hi all,

I’ve been looking for a facility to specify the tablespace of an index that is implicitly created when adding a PK constraint. It turns out that this does indeed exist, though I could find no mention of it in the documentation.

ALTER TABLE {table} ADD CONSTRAINT {constraint} PRIMARY KEY ({column(s)} USING INDEX TABLESPACE {tablespace}

The only mention I could find is in reference to the original patch that implemented this feature.  

http://www.postgresql.org/message-id/41072747.8030602@xxxxxxxxxxxxxxxxxxx

I’m glad to see it’s there, but I wonder if this should be documented?

Tim

This is indicated in the "CREATE TABLE" documentation (to which much of the "ALTER TABLE" documentation defers).