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

On Mon, 23 Aug 2004, Philip Warner wrote:

> At 01:04 PM 23/08/2004, Marc G. Fournier wrote:
>
>> not having ALTER SCHEMA to move tablespaces is not a bug
>
> But it does make pg_dump/restore more inclined to fail, so increases the 
> incidence of another bug, which can not be fixed without a global SET 
> DEFAULT TABLESPACE or an ALTER SCHEMA.

'k, you lost me on that one ... how can not having ALTER SCHEMA to move a 
tablespace cause a pg_dump/restore to fail?  Won't the dump/restore 
"store" a "CREATE SCHEMA" onto the new tablespace?  Why would a 
dump/restore issue an ALTER SCHEMA part way through?

Or am I missing something?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664