Re: [pgadmin-support] Can't delete rules

[Dave Page]

Title: Message

Hi Donald, -----Original Message----- From: Donald Fraser [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 10:13 To: [EMAIL PROTECTED] Subject: [pgadmin-support] Can't delete rules pgAdmin Version 1.4.2   1) The syntax for the DROP RULE statement generated by pgAdmin is incorrect. If you try to drop a rule you get the following error.   Actually it is correct, but only for PostgreSQL 7.3 - it seems the syntax was changed :-(. In the meantime, you can use the SQL   DROP RULE rul_setpasswd   to drop it manually.    2) Not a bug, more of a lacking feature: You can't create rules for views, this is a pain as the only way you can update, insert or delete on views is to create rules for them.   Yes, I'm aware of this missing feature - it's probably only going to be implemented in pgAdmin III, rather than pgAdmin II.   Regards, Dave.