Keith Siu <keith(at)kanetop(dot)com> 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