Re: EXPLAIN CREATE TABLE AS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: EXPLAIN CREATE TABLE AS
Date: 2008-10-23 12:58:14
Message-ID: 12792.1224766694@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> It turns out you cannot EXPLAIN on CREATE TABLE AS, but it seems to work
> fine if I extend the grammar as below:

This seems to me to be something that will look like a wart, not a
feature, from the user's point of view. You can't explain CREATE TABLE,
but you can explain CREATE TABLE AS? It's just weird. It feels to me
like exposing an implementation artifact.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2008-10-23 13:23:18 Re: psql Feature request \set query
Previous Message Nikhil Sontakke 2008-10-23 12:41:41 Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1