Home > mailing lists

CREATE TABLES AS looses constraints - Mailing list pgsql-sql

From	Tiaan Wessels
Subject	CREATE TABLES AS looses constraints
Date	May 29, 2003 15:36:04
Msg-id	20030529163556.7EBDE925D04@developer.postgresql.org Whole thread Raw
Responses	Re: CREATE TABLES AS looses constraints (Josh Berkus <josh@agliodbs.com>)
List	pgsql-sql

Tree view

Hi,
It seems as if a CREATE TABLES AS does not duplicate the table constraints. 
How can I enforce this. I need the fastest possible way to make an exact copy 
of a table. This is to support the administrative mechanism in an app where 
changes are made to a mirrored copy of a set of tables first and when happy, 
these are copied to the operational tables.
Regards
Tiaan

pgsql-sql by date:

From: Brian Knox
Date: 29 May 2003, 15:15:40
Subject: "record" datatype - plpgsql

From: "David Olbersen"
Date: 29 May 2003, 16:00:42
Subject: Rows UPDATEd?

CREATE TABLES AS looses constraints - Mailing list pgsql-sql

Previous

Next