Undocumented feature? USING INDEX TABLESPACE

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.
/messages/by-id/41072747.8030602@familyhealth.com.au

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).

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

So it isŠ My bad, apologies for the noise.