| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
| Date: | 2004-08-30 16:35:39 |
| Message-ID: | 7923.1093883739@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> It seems to me that the current implementation is not completed. For
> instance, do you expect someone to be able to remove a tablespace?
Not when it still contains objects.
> At the
> time it is not always possible, because all objects cannot be moved away
> from a tablespace (namely sequence, as it is considered useless to move
> them, what looks true from a performance perspective, but not from an
> administrator perspective).
The sequences are in the same tablespace as the system catalogs of the
database they are in, so this objection is moot. (And no, we are not
accepting any suggestions about an ALTER command to relocate pg_class
on the fly...)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2004-08-30 16:45:13 | Re: psql questions: SQL, progname, copyright dates |
| Previous Message | Bruce Momjian | 2004-08-30 16:14:20 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-08-30 21:09:57 | Re: [PATCHES] 8.0.0b1: configure.in cygipc |
| Previous Message | Bruce Momjian | 2004-08-30 16:14:20 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |