Re: cannot get CREATE TABLE AS to work

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
informationtechnology      josh@agliodbs.com   and data management solutions       (415) 565-7293  for law firms, small
businesses      fax  621-2533   and non-profit organizations.       San Francisco