Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE TABLE IF NOT EXISTS AS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CREATE TABLE IF NOT EXISTS AS
Date
Msg-id 10097.1384648849@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TABLE IF NOT EXISTS AS  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: CREATE TABLE IF NOT EXISTS AS  ("David E. Wheeler" <david@justatheory.com>)
Re: CREATE TABLE IF NOT EXISTS AS  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Tree view 
"David E. Wheeler" <david@justatheory.com> writes:
> Co-worker asked a question I could not answer: Why is IF NOT EXISTS not supported by CREATE TABLE AS?

That's an even worse idea than plain CREATE IF NOT EXISTS (which was
put in over vocal objections from me and some other people).  Not only
would you not have the faintest clue as to the properties of the table
afterwards, but no clue as to its contents either.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core
Next
From: Tom Lane
Date:
Subject: Re: pre-commit triggers