From: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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 20:05:28 |
Message-ID: | 60C70888-3841-432F-B50B-7415E2915C30@justatheory.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Nov 16, 2013, at 4:40 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> 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.
You mean that, after running it, one cannot tell whether or not a new table was created or not without looking at it? I guess that makes sense, though sometimes I like to tell the system to assume that I know what I’m doing -- e.g., that either outcome works for me.
Not essential as a core feature, mind you; I can use DO to accomplish the same thing. It’s just a bit more work that way. And perhaps that’s for the best.
Best,
David
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-11-17 20:12:32 | Re: proposal: simple date constructor from numeric values |
Previous Message | David E. Wheeler | 2013-11-17 20:02:59 | Re: additional json functionality |