Skip site navigation (1) Skip section navigation (2)

Updated ALTER TABLE ... SET TABLESPACE patch

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 (view raw or flat)
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: altertable2.diff
Description: text/plain (16.6 KB)

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2004-06-30 15:21:13
Subject: Re: patch queue reminder
Previous:From: Dennis BjorklundDate: 2004-06-30 13:18:41
Subject: psql schema permissions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group