Drop view

From: Keith Siu <keith(at)kanetop(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Drop view
Date: 2001-05-09 10:51:01
Message-ID: 3AF92115.BB478825@kanetop.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Bax 2001-05-09 11:46:19 Re: Questions about indexes
Previous Message Rosa Maria Carro Salas 2001-05-09 09:45:52 Charset and encoding