Re: Can't delete rules

Hi Donald,

-----Original Message-----
From: Donald Fraser [mailto:demolish(at)cwgsy(dot)net]
Sent: 29 November 2002 10:13
To: pgadmin-support(at)postgresql(dot)org
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.