diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-01-10 17:50:49 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-01-10 17:50:49 +0000 |
| commit | d70df16a76603e806e32e68da85c8fd8fc13cc5a (patch) | |
| tree | c265fd4560704e040003eef325ec89df2f4d891c /src/test/regress/expected/triggers.out | |
| parent | 6cfa6cb95eb65badf5c02d9b7214ae0a2301a68f (diff) | |
| download | postgresql-d70df16a76603e806e32e68da85c8fd8fc13cc5a.tar.gz | |
Fix up for recent changes in elog error messages.
Some behavior of the triggers test cases changed for the least week or two;
now back to the usual expected behavior.
Diffstat (limited to 'src/test/regress/expected/triggers.out')
| -rw-r--r-- | src/test/regress/expected/triggers.out | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/src/test/regress/expected/triggers.out b/src/test/regress/expected/triggers.out index c4cf5b12b0..17a17d34c3 100644 --- a/src/test/regress/expected/triggers.out +++ b/src/test/regress/expected/triggers.out @@ -40,27 +40,25 @@ QUERY: insert into fkeys2 values (30, '3', 2); QUERY: insert into fkeys2 values (40, '4', 5); QUERY: insert into fkeys2 values (50, '5', 3); QUERY: insert into fkeys2 values (70, '5', 3); -ERROR: check_fkeys2_pkey_exist: tuple references non-existing key in pkeys QUERY: insert into fkeys values (10, '1', 2); QUERY: insert into fkeys values (30, '3', 3); QUERY: insert into fkeys values (40, '4', 2); QUERY: insert into fkeys values (50, '5', 2); QUERY: insert into fkeys values (70, '5', 1); -ERROR: check_fkeys_pkey_exist: tuple references non-existing key in pkeys QUERY: insert into fkeys values (60, '6', 4); -ERROR: check_fkeys_pkey2_exist: tuple references non-existing key in fkeys2 QUERY: delete from pkeys where pkey1 = 30 and pkey2 = '3'; NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted -ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys +NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted QUERY: delete from pkeys where pkey1 = 40 and pkey2 = '4'; NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted QUERY: update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 50 and pkey2 = '5'; NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted -ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys +NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted QUERY: update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 10 and pkey2 = '1'; NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted +ERROR: Cannot insert a duplicate key into a unique index QUERY: DROP TABLE pkeys; QUERY: DROP TABLE fkeys; QUERY: DROP TABLE fkeys2; |