Re: tablespace and sequences?

At 01:47 PM 20/08/2004, Tom Lane wrote:
>But someone
>needs to take a close look at pg_dump's logic to see if this can work.

Not sure where the issues lie, but anything that can reside in a tablespace 
(table, index,...anything else?), needs to dump it's definition without 
reference to a tablespace, and pg_dump needs to be modified to dump the 
tablespace name in the TOC entry, and pg_restore needs to maintain 
'current' tablespace the same way it does schemas. Backend then needs to 
obey the variable setting.

What have I missed? I can do the pg_dump stuff if noone else wants to.





----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 03 5330 3172          |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                 |    --________--
PGP key available upon request,  |  /
and from pgp.mit.edu:11371       |/