Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
От | M Sarwar |
---|---|
Тема | Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints |
Дата | |
Msg-id | DM4PR19MB5978AAB4E24FC60F126BC1BBD3F42@DM4PR19MB5978.namprd19.prod.outlook.com обсуждение исходный текст |
Ответ на | AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints (M Sarwar <sarwarmd02@outlook.com>) |
Ответы |
Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
|
Список | pgsql-admin |
Sent: Wednesday, May 22, 2024 6:38 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
Am 22.05.24 um 23:15 schrieb M Sarwar
Datum: 22. Mai 2024
An: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Cc:
Betreff: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
This is a trigger related question.
Table, test_part_details_all_mcm_init has a trigger, tr_test_part_details_all_mcm_init.
CREATE TRIGGER tr_test_part_details_all_mcm_init
AFTER INSERT
ON bx.test_part_details_all_mcm_init
FOR EACH ROW
EXECUTE FUNCTION bx.tr_fn_test_part_details_all_mcm_init();
Function, bx.tr_fn_test_part_details_all_mcm_init() INSERTs a row into another table, bx.test_part_details_all_mcm_mid
Table, bx.test_part_details_all_mcm_mid has a constraint,
CONSTRAINT cons_unique_for_concatenated_view UNIQUE (start_time_numeric, stop_time_numeric, test_action, part_type, fixture_id, run_id, auxid1_build_id, auxid2_asic_id, serial_number, part_pf)
When I INSERT a data into the table Table, test_part_details_all_mcm_init , trigger is not checking CONSTRAINT cons_unique_for_concatenated_view while INSERTing the data in bx.test_part_details_all_mcm_mid. I am expecting that anything violating the constraint cons_unique_for_concatenated_view will throw an error. Instead of that it is allowing to INSERT the data.
What is that I am missing here?
Thanks,
Sarwar
В списке pgsql-admin по дате отправления:
Предыдущее
От: M SarwarДата:
Сообщение: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
Следующее
От: "David G. Johnston"Дата:
Сообщение: Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints