| From: | "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: create view problem |
| Date: | 2006-06-05 11:56:01 |
| Message-ID: | b0a3bf780606050456i4be1577dua75a012aeaaa0252@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 6/5/06, Thomas Hallgren wrote:
> Chris Velevitch wrote:
> > Why doesn't explain work with create views? There's nothing in the
> > documentation saying it shouldn't.
> >
> No? The documentation for explain clearly states that the statement that follow the EXPLAIN
> keyword is "Any SELECT, INSERT, UPDATE, DELETE, EXECUTE, or DECLARE statement". I don't see
> CREATE (or any other ddl statement) in that list.
I stand corrected.
But, wouldn't you want to see the execution plan for the select
statement that appears in the create? And besides, a more meaning
error message should be generated afterall it's not a syntax error,
but a "that type of statement is not allowed in the EXPLAIN command"
type of error.
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Berend Tober | 2006-06-05 12:20:23 | Re: What is the point of create or replace view command |
| Previous Message | Antonios Katsikadamos | 2006-06-05 10:39:33 | PROBLEM windows postgres installation |