Horton

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

Andreas Karlsson <andreas@proxel.se>

View thread View on postgr.es
From: Andreas Karlsson <andreas@proxel.se>
To: Michael Paquier <michael@paquier.xyz>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2019-02-06T15:23:44Z
Lists: pgsql-hackers

Attachments

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

Commits

  1. Fix support for CREATE TABLE IF NOT EXISTS AS EXECUTE