Keith Siu <[EMAIL PROTECTED]> writes:
> 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"

Try quoting the name properly:

        drop view " all staff";

BTW, 6.5.3 is ancient.  Consider updating.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to