Can't delete rules

From: "Donald Fraser" <demolish(at)cwgsy(dot)net>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Can't delete rules
Date: 2002-11-29 10:13:04
Message-ID: 002c01c2978f$e8d759a0$1664a8c0@DEMOLITION
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

2002-11-28 13:58:47 - SQL (CISX): DROP RULE rul_setpasswd ON vtbl_user_setpasswd

2002-11-28 13:58:47 - *******************************************************************
2002-11-28 13:58:47 - Error(s)
2002-11-28 13:58:47 - *******************************************************************
2002-11-28 13:58:47 - Error in pgAdmin II:basActions.Drop: -2147467259 - ERROR: parser: parse error at or near "ON"
2002-11-28 13:58:47 - The following error(s) have been logged:

-2147467259 - ERROR: parser: parse error at or near "ON"

2002-11-28 13:58:47 - Windows Version: Windows 2000 v5.0 build 2195 Service Pack 2
2002-11-28 13:58:47 - pgSchema Version: 1.4.1
2002-11-28 13:58:47 - MDAC Version: 2.5
2002-11-28 13:58:47 - DBMS Version: 07.02.0004 PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC 2.96

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.

Regards Donald

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-11-29 11:29:14 Re: Can't delete rules
Previous Message Krystian Brazulewicz 2002-11-29 09:07:16 unsubscribe