Postgres Pro
Downloads
Home   >   mailing lists

Re: create view problem - Mailing list pgsql-general

From Tom Lane
Subject Re: create view problem
Date
Msg-id 27961.1149256378@sss.pgh.pa.us
Whole thread Raw
In response to create view problem  ("Chris Velevitch" <chris.velevitch@gmail.com>)
Responses Re: create view problem
List pgsql-general
Tree view 
"Chris Velevitch" <chris.velevitch@gmail.com> 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 you
typed something like

    junk here
    create view v1 ...

            regards, tom lane

pgsql-general by date:

Previous
From: John Sidney-Woollett
Date:
Subject: Re: Querying for strings that match after prefix
Next
From: Tom Lane
Date:
Subject: Re: Getting "timeout expired" error almost immediately (20-200ms)