| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
| Date: | 2004-08-23 14:06:48 |
| Message-ID: | 200408231406.i7NE6m309047@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2004-08-23 14:07:29 | Re: monetary bug |
| Previous Message | Mike Mascari | 2004-08-23 13:11:18 | Re: monetary bug |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-08-23 14:08:34 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
| Previous Message | Markus Bertheau | 2004-08-23 11:50:35 | Re: array_in: '{}}'::text[] |