Re: ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE) - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE)
Date
Msg-id 40EBA406.4020801@familyhealth.com.au
Whole thread Raw
In response to ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE)  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: ALTER xx SET TABLESPACE (was bug in DROP TABLESPACE)
Re: ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE)
List pgsql-hackers
> 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



pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE)
Next
From: Honza Pazdziora
Date:
Subject: Re: Nested Transaction TODO list