Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;

From: Andreas Karlsson <andreas(at)proxel(dot)se>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;
Date: 2019-02-06 15:23:44
Message-ID: 2c6f2b5b-a673-fd1c-ad9c-1c7676cee7d6@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/6/19 12:49 PM, Michael Paquier wrote:
> A test case in select_into.sql would be nice. Should we back-patch
> that? It seems to me that this qualifies as a bug fix, and I don't
> see a reason to not support it knowing that we have the infrastructure
> for that.

I added a test in create_table.sql where the test for the other form of
CTAS IF NOT EXISTS is.

I have no idea if something like this should be back patched. I will add
it to the commit fest either way so it is not lost.

Andreas

Attachment Content-Type Size
ctas-exec-ifne-v2.sql application/sql 3.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-02-06 16:04:26 Re: Refactoring IndexPath representation of index conditions
Previous Message Timmer, Marius 2019-02-06 15:19:56 Re: [PATCH] pg_hba.conf : new auth option : clientcert=verify-full