Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE ... REPLACE WITH - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: ALTER TABLE ... REPLACE WITH
Date
Msg-id 1292355834.2737.4606.camel@ebony
Whole thread Raw
In response to Re: ALTER TABLE ... REPLACE WITH  (Josh Berkus <josh@agliodbs.com>)
Responses Re: ALTER TABLE ... REPLACE WITH  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
On Tue, 2010-12-14 at 11:34 -0800, Josh Berkus wrote:

> In order for REPLACE WITH to be really useful, though, we need a
> command cloning at table design with *all* constraints, FKs, keys, and
> indexes.  Currently, I still don't think we have that ... do we? 

Being able to vary the indexes when we REPLACE is a good feature.

We only need to check that datatypes and constraints match.

-- Simon Riggs           http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE ... REPLACE WITH
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE ... REPLACE WITH