I just posted this idea with a new heading. ALTER seems like the right approach, but notice we need to complete another TODO item to allow tablespace movement of databases and schemas.
--------------------------------------------------------------------------- Fabien COELHO wrote: > > Dear Tom, > > >> o remove non-portable TABLESPACE clause from CREATE TABLE and > >> use a new default_tablespace SET variable > > > > I'm coming around to the conclusion that this is simply a bad idea. > > I agree that the "set" approach is error prone. > > Another idea was to issue an "ALTER" after the CREATE. > > That would move the empty table from one tablespace to another, at small > cost. If it fails, it is simply ignored by the restoration process, > but the table was already created so it exists. > > > What we might want to do is invent a --notablespace option for pg_dump, > > comparable to --noowner, to let someone make a dump that contains no > > TABLESPACE clauses. > > (1) --notablespace would be useful, but it would not fix the problem > I had in mind, i.e. the transfer (possibly after a crash) of data > to another base which would not have these tablespaces. If the disk > is crashed, I cannot redo the pg_dump. > > (2) thus it would help to be able to decide this at "restore" time. > I think that one of the implementation idea was to store the > information into some headers. > > (3) possible current workaround for the desperate admin: > (a) create fake tablespaces as necessary... > (b) pg_restore ... | sed 's/TABLESPACE .*//' | psql ... > > Have a nice day, > > -- > Fabien Coelho - [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
