Undocumented feature? USING INDEX TABLESPACE

From: Tim Kane <tim(dot)kane(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Undocumented feature? USING INDEX TABLESPACE
Date: 2013-10-30 10:32:20
Message-ID: CE9690B4.4ADB1%tim.kane@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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@familyhealth.com.au

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

Tim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Elliot 2013-10-30 12:07:03 Re: Undocumented feature? USING INDEX TABLESPACE
Previous Message Gregory Haase 2013-10-29 21:55:32 Re: json datatype and table bloat?