I'd like it applied, but change it to 'SET DEFAULT TABLESPACE' perhaps...?
Chris
Bruce Momjian wrote:
Would people like this applied to 8.0? It addresses another of the tablespace deficiency.
One item of concern is that it moves the default location for new items created, and does not move items already created in the tablespace itself. This conflicts with ALTER TABLE/INDEX which moves the actual objects. I am not sure how we should address this.
---------------------------------------------------------------------------
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 schema to the new tablespace.
Docs, regression test and tab-completion included.
There were a few places which conflicted with my alter index patch and I've tried to edit the diff where possible to allow for easy applying.
Gavin
Content-Description:
[ Attachment, skipping... ]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])