public inbox for [email protected]  

help / color / mirror / Atom feed

From: Roger Mason <[email protected]>
To: pgsql-novice <[email protected]>
Subject: Re: trigger fails
Date: Sun, 29 Aug 2021 09:58:09 -0230
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwbT_8bzKcJohUVmR_N--x5h9X-dB2rhozz6b99ynd6rpw@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwbT_8bzKcJohUVmR_N--x5h9X-dB2rhozz6b99ynd6rpw@mail.gmail.com>

Hello,

David G. Johnston writes:

> On Sat, Aug 28, 2021 at 7:04 AM Roger Mason <[email protected]> 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).

I have not been able to get this to work: the trigger runs and the
trigger function is called but no new data are inserted into the target
table.  Having spent several days on this without result it is time to
give up.

Thanks again for your help.

Roger

view thread (9+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: trigger fails
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox