Kyle Bateman wrote:
Hi Jan: But when I create it with "create constraint trigger" as shown next, the trigger doesn't seem to be invoked. It says it is created, but it allows data to pass that would not be allowed with the "create trigger." So I'm assuming I'm doing something wrong.
create constraint trigger prd_part_tr_iu after insert or update on prd_parm
deferrable initially deferred
for each row execute procedure prd_parm_tf_iu();
OK, here's a reply to my own post. I've got the constraint trigger working now. The problem was that it was never getting dropped. I still don't know how to drop the constraint. I thought by dropping the trigger function it would get the idea. When I ran the create constraint again, it said it was created (no errors) so I figured everything was OK, but it was still running the previously defined constraint (apparently).
I dropped the table and started from scratch and it seems to work fine now.
So is there a way to "drop constraint trigger" without having to drop the table?
Kyle
