Re: Fixing PKs and Uniques in tablespaces - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Fixing PKs and Uniques in tablespaces
Date
Msg-id 40FF6CF9.8010107@familyhealth.com.au
Whole thread Raw
In response to Re: Fixing PKs and Uniques in tablespaces  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Yes.  This is horribly ugly, and I suspect that you cannot do it
> without making TABLESPACE a fully-reserved word.

No, I've already done it and it works just fine.  What is your 
suggestion then?  Just assume the name of the index it will get?

Also, I realised that the pg_get_serial_sequence() doesn't solve the 
whole sequence autonaming problem  :(  Specifically, dump entries like this:

COMMENT ON SEQUENCE blah_seq IS 'asdfsdfa';

Chris


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fixing PKs and Uniques in tablespaces
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Fixing PKs and Uniques in tablespaces