Trying to understand odd trigger behavior

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: Trying to understand odd trigger behavior
Date: 2018-06-15 04:04:24
Message-ID: 20180615040424.GA18759@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think I know what is happening, but I wanted to see if my understanding
is correct.

I have a perl after insert trigger for a table with a non-null column element
and I am getting an occasional error when the trigger executes for
printing a null value which is $TD->{new}{element}. However, I do the
insert with an on conflict that converts it into an update. And I have
a before update trigger that blocks changing the record, but returns null
if the old and new records are the same.

My theory is that the insert trigger is firing even though the action
got changed to an update and that because the update trigger cancelled
the update, there is no new record. So I should just test for $TD->{new}
being doing before doing stuff.

Does that sound correct?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-06-15 06:54:52 Re: Trying to understand odd trigger behavior
Previous Message Peter Eisentraut 2018-06-15 04:02:02 Re: Can I disable sslcert/sslkey in pg_service.conf?