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

2005-06-08 Thread Bruce Momjian
Thanks, removed. --- Tom Lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > I must have missed something (likely, as I've been away from a computer > > for 6 weeks) but didn't we scrap the idea of schemas having a de

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

2005-06-08 Thread Bruce Momjian
Patch withdrawn by author --- not needed. --- Gavin Sherry wrote: > This patch implements ALTER SCHEMA ... SET TABLESPACE. > > This changes the default schema tablespace but does not attempted to move > objects within the s

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

2005-06-08 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > I must have missed something (likely, as I've been away from a computer > for 6 weeks) but didn't we scrap the idea of schemas having a default > tablespace? Yeah, we did, but Bruce has still got that old patch of yours in his to-do queue. It's irrelevan

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

2005-06-08 Thread Gavin Sherry
On Sat, 4 Jun 2005, Bruce Momjian wrote: > > I am thinking some day we will need: > > ALTER SCHEMA ... SET NEW TABLESPACE > > and > > ALTER SCHEMA ... SET CURRENT TABLESPACE > > to specify if existing objects are moved, but at this point we aren't > going to get the later in 8.1, so I

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

2005-06-04 Thread Bruce Momjian
I am thinking some day we will need: ALTER SCHEMA ... SET NEW TABLESPACE and ALTER SCHEMA ... SET CURRENT TABLESPACE to specify if existing objects are moved, but at this point we aren't going to get the later in 8.1, so I guess we will just go with an unadorned stynax. In fac

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

2004-08-20 Thread Bruce Momjian
This has been saved for the 8.1 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 --- Gavin Sherry wrote: > This patch implements ALTER SCHEMA ... SET TABLESPACE. > > This changes the default schema tablespa

[PATCHES] ALTER SCHEMA ... SET TABLESPACE

2004-08-15 Thread Gavin Sherry
This patch implements ALTER SCHEMA ... SET TABLESPACE. This changes the default schema tablespace but does not attempted to move objects within the schema to the new tablespace. Docs, regression test and tab-completion included. There were a few places which conflicted with my alter index patch