Home > mailing lists

Statement level triggers - Mailing list pgsql-general

From	Vincenzo Romano
Subject	Statement level triggers
Date	January 20, 2010 08:28:43
Msg-id	3eff28921001200128l3b189cffv4243099b38fd085f@mail.gmail.com Whole thread Raw
Responses	Re: Statement level triggers (Craig Ringer <craig@postnewspapers.com.au>) Re: Statement level triggers ("Greg Sabino Mullane" <greg@turnstep.com>)
List	pgsql-general

Tree view

Hi all.

What'd be the behavior of a (plpgsql) trigger function when called as
a statement level trigger?
Let's say that a statement will involve more than one row.
The documentation (v8.4.2, "35.1. Overview of Trigger Behavior") says:

"Statement-level triggers do not currently have any way to examine the
individual row(s) modiﬁed by the statement."

Many thanks.

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS

pgsql-general by date:

From: tmp
Date: 20 January 2010, 08:16:57
Subject: Size of row-metadata?

From: "A. Kretschmer"
Date: 20 January 2010, 08:30:24
Subject: Re: Size of row-metadata?

Statement level triggers - Mailing list pgsql-general

Previous

Next