Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

Philip Warner wrote:
> At 03:15 PM 23/08/2004, Tom Lane wrote:
> 
> >I thought the idea was for pg_dump to emit something like
> >
> >         SET magic_tablespace_variable = some_ts;
> >         CREATE TABLE foo (columns...);
> >
> >rather than
> >
> >         CREATE TABLE foo (columns...) TABLESPACE some_ts;
> >
> >the point being...
> 
> Yep.

This brings up another issue.  We now dump a non-standard clause from
pg_dump when using tablespaces:CREATE TABLE xx (    y integer) TABLESPACE tmp;

We avoided this with oids but it seems we have added another.  I don't
see a good way of avoiding this like we had with oids.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073