Re: Determining if a table really changed in a trigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mitar <mmitar(at)gmail(dot)com>
Cc: Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Determining if a table really changed in a trigger
Date: 2021-11-06 13:43:21
Message-ID: 497190.1636206201@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mitar <mmitar(at)gmail(dot)com> writes:
> Anyone? Any way to determine the number of affected rows in a statement trigger?

Check the size of the transition relation.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitar 2021-11-06 20:04:56 Re: Determining if a table really changed in a trigger
Previous Message Peter J. Holzer 2021-11-06 11:51:21 Re: Question: Is it possible to get the new xlog position after query execution?