Re: cannot get CREATE TABLE AS to work

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)COM>, sqllist <pgsql-sql(at)postgresql(dot)org>
Subject: Re: cannot get CREATE TABLE AS to work
Date: 2001-03-09 18:36:55
Message-ID: 3AA922C7.CFD72698@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Robert,

> I suspect that the INSERT INTO SELECT in this case will take longer than a
> CREATE TABLE AS because of the referential integrity check needed on every
> INSERT (per Tom Lane).

In that case, what about:

a) dropping the referential integrity check;
2) making the referential integrity check deferrable (there's a way to
do this, it was discussed a couple weeks ago - ask Tom).

-Josh Berkus

--
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alder 2001-03-09 19:05:38 SQL Dummy Needs Help
Previous Message Tom Lane 2001-03-09 17:12:58 Re: cannot get CREATE TABLE AS to work