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