triger and transaction - Mailing list pgsql-general

From SunWuKung
Subject triger and transaction
Date
Msg-id 1146126846.370973.205800@g10g2000cwb.googlegroups.com
Whole thread Raw
Responses Re: triger and transaction  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
If a transaction inserts rows to two tables will a procedure invoked by
an "after insert on each row" trigger on one table see all the records
inserted in the other table?

In other words - will the transaction run completely before the trigger
is fired?

Thanks for the help.
Balázs


pgsql-general by date:

Previous
From: "Schnabl, Sebastian"
Date:
Subject: Postgres 8.1 sequences and 'CALL'-syntax
Next
From: Kris Jurka
Date:
Subject: Re: Postgres 8.1 sequences and 'CALL'-syntax