Re: EXPLAIN CREATE TABLE AS

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: EXPLAIN CREATE TABLE AS
Date: 2008-10-23 13:37:45
Message-ID: 200810231537.48574.dfontaine@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le jeudi 23 octobre 2008, Tom Lane a écrit :
> 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.

As a user, I'm disagreeing about the weirdness of it. +1 for Peter's
initiative.

Regards,
--
dim

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2008-10-23 13:40:54 Re: EXPLAIN CREATE TABLE AS
Previous Message Magnus Hagander 2008-10-23 13:31:48 Re: pg_hba options parsing