> 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