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

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, 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 04:56:58
Message-ID: 6.1.1.1.0.20040823145358.05033840@203.8.195.10
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

At 02:28 PM 23/08/2004, Tom Lane wrote:

>There's been some talk of that, but AFAICS it's not related to an ALTER
>SCHEMA SET [DEFAULT] TABLESPACE command.

So, if you do make the changes, will the schema definition be affected by
those changes, or do you expect the tablespace to be embedded in the CREATE
SCHEMA command?

> (And no, I've not yet lifted
>a finger on this, though I'm willing to handle the backend side of it
>if there's consensus to handle dumping this way.)

Let me know when consensus happens. I've got a patch waiting on the syntax
of the SET command. Otherwise, I'll need to use alter commands.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp.mit.edu:11371 |/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-23 05:15:09 Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Previous Message Dennis Bjorklund 2004-08-23 04:49:33 Re: monetary bug

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-08-23 05:15:09 Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Previous Message Tom Lane 2004-08-23 04:28:48 Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE