Re: trigger fails - Mailing list pgsql-novice

From David G. Johnston
Subject Re: trigger fails
Date
Msg-id CAKFQuwbT_8bzKcJohUVmR_N--x5h9X-dB2rhozz6b99ynd6rpw@mail.gmail.com
Whole thread Raw
In response to trigger fails  (Roger Mason <rmason@mun.ca>)
Responses Re: trigger fails
List pgsql-novice
On Sat, Aug 28, 2021 at 7:04 AM Roger Mason <rmason@mun.ca> wrote:

    get_final_energy (NEW.jid);


If you want to use this function within a trigger it should be redefined to accept "NEW" (i.e., the table record itself), not the jid column (IOW, don't perform a select on the table during the middle of the trigger execution).

David J.

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: trigger fails
Next
From: Roger Mason
Date:
Subject: Re: trigger fails