From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql@ac6rm.net
Cc: pgsql-sql@postgresql.org
Subject: Re: TRIGGERed INSERTS
Date: Fri, 18 Oct 2002 10:22:53 -0400
Message-ID: <17482.1034950973@sss.pgh.pa.us> (raw)
In-Reply-To: <63387.24.52.245.104.1034949598.squirrel@webmail.ac6rm.net>
References: <63387.24.52.245.104.1034949598.squirrel@webmail.ac6rm.net>
"Martin Crundall" <pgsql@ac6rm.net> writes:
> Some of the data tables have "AFTER INSERT" TRIGGERs on them that, in
> turn, insert some subordinate items into parallel data tables and the
> central pointer/ordering table.
It looks to me like AFTER triggers are fired upon return to the main
loop in postgres.c, thus only at the end of a querystring sent by the
client. This is perhaps wrong, but I'm not sure that allowing them to
fire during plpgsql functions would be a good thing either.
regards, tom lane
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: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql@ac6rm.net
Subject: Re: TRIGGERed INSERTS
In-Reply-To: <17482.1034950973@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox