/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 985 create table rules_base(f1 int, f2 int); table 986 insert into rules_base values(1,2), (11,12); 987 create rule r1 as on update to rules_base do instead 988 select * from rules_base where f1 = 1 for update; 989 update rules_base set f2 = f2 + 1; 990 create or replace rule r1 as on update to rules_base do instead 991 select * from rules_base where f1 = 11 for update of rules_base; 992 update rules_base set f2 = f2 + 1; 993 create or replace rule r1 as on update to rules_base do instead 994 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 985 create table rules_base(f1 int, f2 int); table 986 insert into rules_base values(1,2), (11,12); 987 create rule r1 as on update to rules_base do instead 988 select * from rules_base where f1 = 1 for update; 989 update rules_base set f2 = f2 + 1; 990 create or replace rule r1 as on update to rules_base do instead 991 select * from rules_base where f1 = 11 for update of rules_base; 992 update rules_base set f2 = f2 + 1; 993 create or replace rule r1 as on update to rules_base do instead 994 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 985 create table rules_base(f1 int, f2 int); table 986 insert into rules_base values(1,2), (11,12); 987 create rule r1 as on update to rules_base do instead 988 select * from rules_base where f1 = 1 for update; 989 update rules_base set f2 = f2 + 1; 990 create or replace rule r1 as on update to rules_base do instead 991 select * from rules_base where f1 = 11 for update of rules_base; 992 update rules_base set f2 = f2 + 1; 993 create or replace rule r1 as on update to rules_base do instead 994 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 985 create table rules_base(f1 int, f2 int); table 986 insert into rules_base values(1,2), (11,12); 987 create rule r1 as on update to rules_base do instead 988 select * from rules_base where f1 = 1 for update; 989 update rules_base set f2 = f2 + 1; 990 create or replace rule r1 as on update to rules_base do instead 991 select * from rules_base where f1 = 11 for update of rules_base; 992 update rules_base set f2 = f2 + 1; 993 create or replace rule r1 as on update to rules_base do instead 994 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); table 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 996 create table rules_base(f1 int, f2 int); 997 insert into rules_base values(1,2), (11,12); 998 create rule r1 as on update to rules_base do instead 999 select * from rules_base where f1 = 1 for update; 1000 update rules_base set f2 = f2 + 1; 1001 create or replace rule r1 as on update to rules_base do instead 1002 select * from rules_base where f1 = 11 for update of rules_base; 1003 update rules_base set f2 = f2 + 1; 1004 create or replace rule r1 as on update to rules_base do instead 1005 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
H A D | rules.sql | 997 create table rules_base(f1 int, f2 int); table 998 insert into rules_base values(1,2), (11,12); 999 create rule r1 as on update to rules_base do instead 1000 select * from rules_base where f1 = 1 for update; 1001 update rules_base set f2 = f2 + 1; 1002 create or replace rule r1 as on update to rules_base do instead 1003 select * from rules_base where f1 = 11 for update of rules_base; 1004 update rules_base set f2 = f2 + 1; 1005 create or replace rule r1 as on update to rules_base do instead 1006 select * from rules_base where f1 = 11 for update of old; -- error [all …]
|