Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Karel ZakDate: 2004-08-23 14:07:29
Subject: Re: monetary bug
Previous:From: Mike MascariDate: 2004-08-23 13:11:18
Subject: Re: monetary bug

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-08-23 14:08:34
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Previous:From: Markus BertheauDate: 2004-08-23 11:50:35
Subject: Re: array_in: '{}}'::text[]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group