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? > > "view" is not nearly 16 characters into that command. I think you > typed something like > > junk here > create view v1 ... Yes, I had "explain" in front.
Why doesn't explain work with create views? There's nothing in the documentation saying it shouldn't. If this is deliberate, the error should state that. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au
