| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Updated ALTER TABLE ... SET TABLESPACE patch |
| Date: | 2004-06-30 14:19:05 |
| Message-ID: | Pine.LNX.4.58.0407010015360.19772@linuxworld.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Hi all,
Attached is an updated ALTER TABLE ... SET TABLESPACE patch.
It uses the block by block copy mechanism proposed by Tom and handles i)
ALTER TABLE <index> .... and ii) Copying of TOAST tables and the TOAST
table's index.
It doesn't handle copying of system tables (pg_largeobject) and, in the
interests of code reuse, the patch fiddles with the code used by CLUSTER.
This isn't great but I wanted to get a patch in before 1 July since I
think the feature is very important -- even for the first release.
Thanks,
Gavin
| Attachment | Content-Type | Size |
|---|---|---|
| altertable2.diff | text/plain | 16.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-06-30 15:21:13 | Re: patch queue reminder |
| Previous Message | Dennis Bjorklund | 2004-06-30 13:18:41 | psql schema permissions |