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

Ramanarayana <raam.soft@gmail.com>

From: Ramanarayana <raam.soft@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Andreas Karlsson <andreas@proxel.se>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2019-03-10T13:26:57Z
Lists: pgsql-hackers
Hi,

Will it be helpful if the comments section of ExecuteStmt in gram.y is
updated to include the IF NOT EXISTS clause.Something like this

CREATE TABLE <name> [IF NOT EXISTS] AS EXECUTE <plan_name> [(params, ...)]

Regards,
Ram.

Commits

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