Drop view - Mailing list pgsql-general

From Keith Siu
Subject Drop view
Date
Msg-id 3AF92115.BB478825@kanetop.com
Whole thread Raw
Responses Re: Drop view  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I 'm the fresh user in pgsql,

And now I'm using version 6.5.3 under linux red hat 6.2
I ve made a mistake to create a view " all staff" and can't drop it
everytime I descript or drop the view , it appear Error as below  :

template1> \d all staff;
ERROR: nodeRead : Bad type 0
template1>drop view all staff;
ERROR :parser: parser error at or near "all"


Kindly advise how to drop the view without error,

Thanks & regards


pgsql-general by date:

Previous
From: Roger Wernersson
Date:
Subject: Re: pg_restore problems?
Next
From: "Mark R"
Date:
Subject: Newbie HOWTO