pgsql: Fix support for CREATE TABLE IF NOT EXISTS AS EXECUTE

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix support for CREATE TABLE IF NOT EXISTS AS EXECUTE
Date: 2019-02-15 08:14:24
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix support for CREATE TABLE IF NOT EXISTS AS EXECUTE

The grammar IF NOT EXISTS for CTAS is supported since 9.5 and documented
as such, however the case of using EXECUTE as query has never been
covered as EXECUTE CTAS statements and normal CTAS statements are parsed
separately.

Author: Andreas Karlsson
Discussion: https://postgr.es/m/[email protected]
Backpatch-through: 9.5

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/331a613e9d363febfee8508e8de545fd84624758

Modified Files
--------------
src/backend/parser/gram.y | 18 ++++++++++++++++++
src/test/regress/expected/create_table.out | 14 ++++++++++++++
src/test/regress/sql/create_table.sql | 8 ++++++++
3 files changed, 40 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2019-02-15 14:14:55 pgsql: Use standard diff separator for regression.diffs
Previous Message Thomas Munro 2019-02-15 02:07:17 pgsql: Fix race in dsm_attach() when handles are reused.