Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't delete rules - Mailing list pgadmin-support

From Dave Page
Subject Re: Can't delete rules
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8128CAE@mail.vale-housing.co.uk
Whole thread Raw
In response to Can't delete rules  ("Donald Fraser" <demolish@cwgsy.net>)
List pgadmin-support
Tree view
Hi Donald,
-----Original Message-----
From: Donald Fraser [mailto:demolish@cwgsy.net]
Sent: 29 November 2002 10:13
To: pgadmin-support@postgresql.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.

pgadmin-support by date:

Previous
From: "Donald Fraser"
Date:
Subject: Can't delete rules
Next
From: "Dave Page"
Date:
Subject: Re: Can't delete rules