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
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.
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2004-06-30 15:21:13|
|Subject: Re: patch queue reminder |
|Previous:||From: Dennis Bjorklund||Date: 2004-06-30 13:18:41|
|Subject: psql schema permissions|