| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE) |
| Date: | 2004-07-07 07:44:18 |
| Message-ID: | Pine.LNX.4.58.0407071742190.29717@linuxworld.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 7 Jul 2004, Christopher Kings-Lynne wrote:
> > 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.
Maybe? You definately do.
In the ALTER DATABASE case you'd also need to lock users out of the
database.
I'm not so sure these additions are necessary for 7.5 though...
Does anyone else have thoughts?
Gavin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2004-07-07 07:46:45 | Re: ALTER xx SET TABLESPACE (was bug in DROP TABLESPACE) |
| Previous Message | Oliver Jowett | 2004-07-07 07:34:51 | Re: Nested Transactions, Abort All |