Re: trigger fails

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Roger Mason <rmason(at)mun(dot)ca>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: trigger fails
Date: 2021-08-28 15:50:40
Message-ID: CAKFQuwbT_8bzKcJohUVmR_N--x5h9X-dB2rhozz6b99ynd6rpw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, Aug 28, 2021 at 7:04 AM Roger Mason <rmason(at)mun(dot)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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Roger Mason 2021-08-29 12:28:09 Re: trigger fails
Previous Message David G. Johnston 2021-08-28 14:38:53 Re: trigger fails