Updated ALTER TABLE ... SET TABLESPACE patch - Mailing list pgsql-patches

From Gavin Sherry
Subject Updated ALTER TABLE ... SET TABLESPACE patch
Date
Msg-id Pine.LNX.4.58.0407010015360.19772@linuxworld.com.au
Whole thread Raw
Responses Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Gavin Sherry <swm@linuxworld.com.au>)
Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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

pgsql-patches by date:

Previous
From: Dennis Bjorklund
Date:
Subject: psql schema permissions
Next
From: Tom Lane
Date:
Subject: Re: patch queue reminder