Re: ALTER TABLE ... REPLACE WITH

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