diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/include/utils/elog.h | 5 | ||||
| -rw-r--r-- | src/test/regress/expected/triggers.out | 13 |
2 files changed, 12 insertions, 6 deletions
diff --git a/src/include/utils/elog.h b/src/include/utils/elog.h index 661187269db..328ab44b0d6 100644 --- a/src/include/utils/elog.h +++ b/src/include/utils/elog.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: elog.h,v 1.55 2003/07/22 22:14:57 tgl Exp $ + * $Id: elog.h,v 1.56 2003/07/24 17:52:49 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -100,6 +100,9 @@ #define ERRCODE_TRANSACTION_RESOLUTION_UNKNOWN MAKE_SQLSTATE('0','8', '0','0','7') #define ERRCODE_PROTOCOL_VIOLATION MAKE_SQLSTATE('0','8', 'P','0','1') +/* Class 09 - Triggered Action Exception */ +#define ERRCODE_TRIGGERED_ACTION_EXCEPTION MAKE_SQLSTATE('0','9', '0','0','0') + /* Class 0A - Feature Not Supported */ #define ERRCODE_FEATURE_NOT_SUPPORTED MAKE_SQLSTATE('0','A', '0','0','0') diff --git a/src/test/regress/expected/triggers.out b/src/test/regress/expected/triggers.out index 363682f50b2..086c9f602c8 100644 --- a/src/test/regress/expected/triggers.out +++ b/src/test/regress/expected/triggers.out @@ -63,26 +63,29 @@ insert into fkeys2 values (40, '4', 5); insert into fkeys2 values (50, '5', 3); -- no key in pkeys insert into fkeys2 values (70, '5', 3); -ERROR: check_fkeys2_pkey_exist: tuple references non-existing key in pkeys +ERROR: tuple references non-existent key +DETAIL: Trigger "check_fkeys2_pkey_exist" found tuple referencing non-existent key in "pkeys". insert into fkeys values (10, '1', 2); insert into fkeys values (30, '3', 3); insert into fkeys values (40, '4', 2); insert into fkeys values (50, '5', 2); -- no key in pkeys insert into fkeys values (70, '5', 1); -ERROR: check_fkeys_pkey_exist: tuple references non-existing key in pkeys +ERROR: tuple references non-existent key +DETAIL: Trigger "check_fkeys_pkey_exist" found tuple referencing non-existent key in "pkeys". -- no key in fkeys2 insert into fkeys values (60, '6', 4); -ERROR: check_fkeys_pkey2_exist: tuple references non-existing key in fkeys2 +ERROR: tuple references non-existent key +DETAIL: Trigger "check_fkeys_pkey2_exist" found tuple referencing non-existent key in "fkeys2". 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 +ERROR: "check_fkeys2_fkey_restrict": tuple is referenced in "fkeys" 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 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 +ERROR: "check_fkeys2_fkey_restrict": tuple is referenced in "fkeys" 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 |