triger and transaction

From: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: triger and transaction
Date: 2006-04-27 08:34:06
Message-ID: 1146126846.370973.205800@g10g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2006-04-27 08:37:41 Re: Postgres 8.1 sequences and 'CALL'-syntax
Previous Message Richard Huxton 2006-04-27 08:27:16 Re: problem with unique text column