Re: Updated ALTER TABLE ... SET TABLESPACE patch - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: Updated ALTER TABLE ... SET TABLESPACE patch
Date
Msg-id 40F20791.5090106@familyhealth.com.au
Whole thread Raw
In response to Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> In fact, now that I think of it, the patch-as-committed already
> introduces some serious headaches for pg_dump: it can't know for sure
> what name will be assigned to constraint indexes (pkey and unique
> indexes) so it has no good way to emit ALTER TABLE SET TABLESPACE
> commands for those indexes.

I guess I'll have to make it punt that the name will be what it
currently is :(

Otherwise, we need to extend the ADD CONSTRAINT syntax.  That would be
handy because the you could specify the TABLESPACE at creation time as well.

Chris


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch