Re: CREATE TABLE IF NOT EXISTS AS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Steve Rehfuss <steve(dot)rehfuss(at)iovation(dot)com>
Subject: Re: CREATE TABLE IF NOT EXISTS AS
Date: 2013-11-17 00:40:49
Message-ID: 10097.1384648849@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"David E. Wheeler" <david(at)justatheory(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-11-17 00:42:58 Re: pre-commit triggers
Previous Message Peter Geoghegan 2013-11-17 00:36:35 Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core