Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints - Mailing list pgsql-admin
From | M Sarwar |
---|---|
Subject | Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints |
Date | |
Msg-id | DM4PR19MB5978AAB4E24FC60F126BC1BBD3F42@DM4PR19MB5978.namprd19.prod.outlook.com Whole thread Raw |
In response to | AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints (M Sarwar <sarwarmd02@outlook.com>) |
Responses |
Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
|
List | 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 by date: