EXPLAIN CREATE TABLE AS

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: EXPLAIN CREATE TABLE AS
Date: 2008-10-23 11:29:44
Message-ID: 49006028.5090805@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

It turns out you cannot EXPLAIN on CREATE TABLE AS, but it seems to work
fine if I extend the grammar as below:

ExplainableStmt:
SelectStmt
| InsertStmt
| UpdateStmt
| DeleteStmt
| DeclareCursorStmt
+ | CreateAsStmt
| ExecuteStmt /* by default all are $$=$1 */
;

It's the same as SELECT INTO after all, which already works. Should
this be added?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-10-23 11:33:25 Re: Deriving Recovery Snapshots
Previous Message Heikki Linnakangas 2008-10-23 10:40:01 Re: Deriving Recovery Snapshots