On Fri, 20 Aug 2004, Bruce Momjian wrote:
Would people like this applied to 8.0? It addresses another of the tablespace deficiency.
This is an extension of tablespaces, and is not required to fix a bug ... therefore, it is a feature, and not eligible for inclusion at this point in the development cycle ...
>
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
-- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])