Search Postgresql Archives

Re: Determining if a table really changed in a trigger

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Determining if a table really changed in a trigger
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Sat, 06 Nov 2021 09:43:21 -0400
Cc: Mark Dilger <mark.dilger@xxxxxxxxxxxxxxxx>, Postgres General <pgsql-general@xxxxxxxxxxxxxx>
Comments: In-reply-to Mitar <mmitar@xxxxxxxxx> message dated "Sat, 06 Nov 2021 08:13:50 +0100"
In-reply-to: <CAKLmikMdcr_hLSJNVy-i+WNiBFftawtV+o4-03=yn0w74fOfEA@mail.gmail.com>
References: <CAKLmikNjiz=zwf9suiAHoBLrRpjLTNsQ=f4PGD3RMFBxzR-3OA@mail.gmail.com> <E35E8F8C-4F85-4FFB-8A98-B1924678874E@enterprisedb.com> <CAKLmikPA6Nj65X_sbSh6XoROLuY_FeXd8AmpxuM-LWw5EnMxpQ@mail.gmail.com> <AD34DA0A-C6F4-4993-953C-36D7D973315D@enterprisedb.com> <CAKLmikMy+90f3GSqeMKsiV-qTX0Zc3VyGDCerrOJHo_usV=K4A@mail.gmail.com> <6526D693-D520-4B94-B44F-4A2770FBF778@enterprisedb.com> <CAKLmikMdcr_hLSJNVy-i+WNiBFftawtV+o4-03=yn0w74fOfEA@mail.gmail.com>

Mitar <mmitar@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Determining if a table really changed in a trigger
  - From: Mitar

References:
- Determining if a table really changed in a trigger
  - From: Mitar
- Re: Determining if a table really changed in a trigger
  - From: Mark Dilger
- Re: Determining if a table really changed in a trigger
  - From: Mitar
- Re: Determining if a table really changed in a trigger
  - From: Mark Dilger
- Re: Determining if a table really changed in a trigger
  - From: Mitar
- Re: Determining if a table really changed in a trigger
  - From: Mark Dilger
- Re: Determining if a table really changed in a trigger
  - From: Mitar

Prev by Date: Re: Question: Is it possible to get the new xlog position after query execution?
Next by Date: Re: Determining if a table really changed in a trigger
Previous by thread: Re: Determining if a table really changed in a trigger
Next by thread: Re: Determining if a table really changed in a trigger
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]