"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> But, wouldn't you want to see the execution plan for the select
> statement that appears in the create?
Then give the EXPLAIN the select statement that appears in the create.
Logically, EXPLAIN of a DDL statement would tell you about the costs
of pe
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
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 statemen
On 6/3/06, Chris Velevitch wrote:
On 6/2/06, Tom Lane wrote:
> "Chris Velevitch" writes:
> > I'm using pg 7.4.5 (cygwin) on win xp sp1.
> > When I enter:-
> > create view v1 as select * from t1;
> > I get:-
> > ERROR: syntax error at or near "view" at character 16
>
> Repeatably?
>
> "vi
On 6/2/06, Tom Lane wrote:
"Chris Velevitch" writes:
> I'm using pg 7.4.5 (cygwin) on win xp sp1.
> When I enter:-
> create view v1 as select * from t1;
> I get:-
> ERROR: syntax error at or near "view" at character 16
Repeatably?
"view" is not nearly 16 characters into that command.
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> I'm using pg 7.4.5 (cygwin) on win xp sp1.
> When I enter:-
> create view v1 as select * from t1;
> I get:-
> ERROR: syntax error at or near "view" at character 16
Repeatably?
"view" is not nearly 16 characters into that command. I think y
I'm using pg 7.4.5 (cygwin) on win xp sp1.
When I enter:-
create view v1 as select * from t1;
I get:-
ERROR: syntax error at or near "view" at character 16
Why?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
---(
dear sir,
i am trying to create view with following query
create view salesQ as
select * from sales, customer where sales.customerkey
= customer.customerkey;
it is giving
ERROR: column "customerkey" duplicated
create view salesQ as
select sales.*, customer.* from sales, customer where
sales.c
