Home > mailing lists

Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query; - Mailing list pgsql-hackers

From	Ramanarayana
Subject	Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;
Date	March 10, 2019 16:26:57
Msg-id	CAKm4Xs5GU-ogL2u4CKCNoGxBK6t1ZXytPTcmubXDCVUJZLYCog@mail.gmail.com Whole thread Raw
In response to	Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTEquery; (Michael Paquier <michael@paquier.xyz>)
Responses	Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTEquery;
List	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.

From: Julien Rouhaud
Date: 10 March 2019, 16:18:26
Subject: Re: Should we increase the default vacuum_cost_limit?

From: Paul Guo
Date: 10 March 2019, 16:55:35
Subject: Re: Batch insert in CTAS/MatView code