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

From: Ramanarayana <raam(dot)soft(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Andreas Karlsson <andreas(at)proxel(dot)se>, 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-03-10 13:26:57
Message-ID: CAKm4Xs5GU-ogL2u4CKCNoGxBK6t1ZXytPTcmubXDCVUJZLYCog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Paul Guo 2019-03-10 13:55:35 Re: Batch insert in CTAS/MatView code
Previous Message Julien Rouhaud 2019-03-10 13:18:26 Re: Should we increase the default vacuum_cost_limit?