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]