Re: USING INDEX TABLESPACE

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> The attached patch allows the specification of the tablespace the index
> is to be created in for unique and pk constraints.  It also fixes the
> dumping of such constraints so that they are restored into the correct
> tablespace, after they have been moved with SET TABLESPACE.  This is
> currently an outstanding pg_dump bug.

Applied.  I also added some code to ruleutils.c to make
pg_get_constraintdef output the USING INDEX TABLESPACE clause at need.

We might want to think about getting pg_dump to rely more on
pg_get_constraintdef and friends, instead of native wit ...

            regards, tom lane