| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: bug in DROP TABLESPACE |
| Date: | 2004-07-07 02:28:47 |
| Message-ID: | 40EB5FDF.8060903@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Tom already mentioned this just after committing tablespaces: 'Minor DROP
> TABLESPACE issue'
>
> http://www.mail-archive.com/pgsql-hackers(at)postgresql(dot)org/msg46540.html
>
> In fact, I see that you contributed to the thread :-).
>
> I think the result of the thread was to make the error message a little
> more helpful and that adding empty files to represent schemas would be a
> pain (think WAL and name collision).
Ah, I must have been in a dream state.
The other thing we need are these two commands:
ALTER DATABASE foo SET TABLESPACE spc;
ALTER SCHEMA foo SET TABLESPACE spc;
I think these should not be considered new features but essential
functionality left out of the original patch.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2004-07-07 04:47:18 | Re: Nested Transactions, Abort All |
| Previous Message | Greg Sabino Mullane | 2004-07-07 01:30:46 | Re: [Re] Re: PREPARE and transactions |