Vadim Passynkov (Vadim.Passynkov) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
RULE ON SELECT with old values.
Long Description
# SELECT version();
version
--------------------------------------------------------------
PostgreSQL 7.1.3 on i386--freebsd4.4, compiled by GCC 2.95.3
# \d routers_password
Table "routers_password"
Attribute | Type | Modifier
-----------+---------+----------
obj_id | integer | not null
userpwd | text |
super | text |
Index: routers_password_pkey
Constraints: (userpwd !~ '[[:space:]]'::text)
(super !~ '[[:space:]]'::text)
# CREATE RULE routers_password_test AS ON SELECT TO routers_password DO INSTEAD SELECT
old.obj_id, old.userpwd, old.super;
ERROR: ON SELECT rule may not use OLD
>From PostgreSQL Documentation:
Within the condition and action, the special table names new and old may be used to
refer to values in the referenced table (the object). new is valid in ON INSERT and ON
UPDATE rules to refer to the new row being inserted or updated. old is valid in ON
SELECT, ON UPDATE, and ON DELETE rules to refer to the existing row being selected,
updated, or deleted.
--
Vadim Passynkov
Sample Code
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
