Its questionable if these are to be interpreted as just changing the default tablespace for subsequent creates, or also moving all objects that were created using the previous tablespace. Since it's indistinguishable whether an object was created using the default from schema/database or given a tablespace explicitely (unless default was 0), I'd opt for version one.
I meant option one - I hadn't considered the second. The thing is though you have to maybe move some stuff on disk as well.
Chris
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
