summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/rules.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/rules.sql')
-rw-r--r--src/test/regress/sql/rules.sql26
1 files changed, 13 insertions, 13 deletions
diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql
index e148489d9a..319a206652 100644
--- a/src/test/regress/sql/rules.sql
+++ b/src/test/regress/sql/rules.sql
@@ -16,9 +16,9 @@ create rule rtest_v1_ins as on insert to rtest_v1 do instead
insert into rtest_t1 values (new.a, new.b);
create rule rtest_v1_upd as on update to rtest_v1 do instead
update rtest_t1 set a = new.a, b = new.b
- where a = current.a;
+ where a = old.a;
create rule rtest_v1_del as on delete to rtest_v1 do instead
- delete from rtest_t1 where a = current.a;
+ delete from rtest_t1 where a = old.a;
--
-- Tables and rules for the constraint update/delete test
@@ -35,21 +35,21 @@ create table rtest_admin (pname text, sysname text);
create rule rtest_sys_upd as on update to rtest_system do (
update rtest_interface set sysname = new.sysname
- where sysname = current.sysname;
+ where sysname = old.sysname;
update rtest_admin set sysname = new.sysname
- where sysname = current.sysname
+ where sysname = old.sysname
);
create rule rtest_sys_del as on delete to rtest_system do (
- delete from rtest_interface where sysname = current.sysname;
- delete from rtest_admin where sysname = current.sysname;
+ delete from rtest_interface where sysname = old.sysname;
+ delete from rtest_admin where sysname = old.sysname;
);
create rule rtest_pers_upd as on update to rtest_person do
- update rtest_admin set pname = new.pname where pname = current.pname;
+ update rtest_admin set pname = new.pname where pname = old.pname;
create rule rtest_pers_del as on delete to rtest_person do
- delete from rtest_admin where pname = current.pname;
+ delete from rtest_admin where pname = old.pname;
--
-- Tables and rules for the logging test
@@ -62,13 +62,13 @@ create rule rtest_emp_ins as on insert to rtest_emp do
insert into rtest_emplog values (new.ename, current_user,
'hired', new.salary, '0.00');
-create rule rtest_emp_upd as on update to rtest_emp where new.salary != current.salary do
+create rule rtest_emp_upd as on update to rtest_emp where new.salary != old.salary do
insert into rtest_emplog values (new.ename, current_user,
- 'honored', new.salary, current.salary);
+ 'honored', new.salary, old.salary);
create rule rtest_emp_del as on delete to rtest_emp do
- insert into rtest_emplog values (current.ename, current_user,
- 'fired', '0.00', current.salary);
+ insert into rtest_emplog values (old.ename, current_user,
+ 'fired', '0.00', old.salary);
--
-- Tables and rules for the multiple cascaded qualified instead
@@ -177,7 +177,7 @@ insert into rtest_v1 values (2, 12);
insert into rtest_v1 values (2, 13);
select * from rtest_v1;
** Remember the delete rule on rtest_v1: It says
-** DO INSTEAD DELETE FROM rtest_t1 WHERE a = current.a
+** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a
** So this time both rows with a = 2 must get deleted
\p
\r