ftest1 (reference) in projects: dports - OpenGrok search results

Project(s)

Full Search
Definition
Symbol
File Path
History
Type

Searched refs:ftest1 (Results 1 – 25 of 236) sorted by relevance

12 3 4 5 6 7 8 9 10

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 429 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE… field 459 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 460 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 475 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 476 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 483 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 487 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 529 insert into fktable(ftest1) values (3); 594 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A D	foreign_key.sql	`96 ftest1 int, field 205 ftest1 = 1; 211 ftest1 = 1 213 ftest1 = 1; 462 ftest1 int, field 490 ftest1 int, field 587 ftest1 int, field 1087 ftest1 = ftest1; 1093 ftest1 = ftest1 + 1; 1132 ftest1 = ftest1; [all …]`
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 101 UPDATE FKTABLE SET ftest1 = NULL WHERE ftest1 = 1; 104 UPDATE FKTABLE SET ftest1 = 1 WHERE ftest1 = 1; 498 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 499 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 514 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 515 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 522 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 526 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 633 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… 101 UPDATE FKTABLE SET ftest1 = NULL WHERE ftest1 = 1; 104 UPDATE FKTABLE SET ftest1 = 1 WHERE ftest1 = 1; 498 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 499 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 514 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 515 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 522 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… 526 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); 633 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); [all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A D	foreign_key.sql	50 CREATE TABLE FKTABLE ( ftest1 int, ftest2 int, ftest3 int, CONSTRAINT constrname FOREIGN KEY(ftest1… field 101 UPDATE FKTABLE SET ftest1 = NULL WHERE ftest1 = 1; 104 UPDATE FKTABLE SET ftest1 = 1 WHERE ftest1 = 1; 498 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 499 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 514 UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed 515 UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail 522 CREATE TABLE FKTABLE (ftest1 cidr, ftest2 timestamp, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable… field 526 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest2, ftest1) REFERENCES pktable); field 633 create table fktable(ftest1 cidr, ftest2 int[], foreign key (ftest1, ftest2) references pktable); field [all …]

12 3 4 5 6 7 8 9 10