Re: Transaction - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Transaction
Date
Msg-id Pine.BSF.4.21.0109171255440.59052-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Transaction  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
List pgsql-general
On Mon, 17 Sep 2001, Mihai Gheorghiu wrote:

> An event triggers a rule / trigger.
> Does this (event + rule/trigger) behave as a transaction, or is it necessary
> to wrap it into BEGIN COMMIT? If yes, BEGIN should be before or after the
> event (in the rule/trigger)?

The rule/trigger runs in the same transaction as the original statement
(if you're not in an explicit transaction, you should get an implicit one
around the statement automatically)


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: plpgsql/cursor
Next
From: Francisco Eriko Barreto Brito
Date:
Subject: Left Joins