From: | Doug McNaught <doug(at)wireboard(dot)com> |
---|---|
To: | "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Transaction |
Date: | 2001-09-17 21:01:46 |
Message-ID: | m3lmjdsf9h.fsf@belphigor.mcnaught.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Mihai Gheorghiu" <tanethq(at)earthlink(dot)net> writes:
> 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)?
It is always inside a transaction, since every SQL statement is a
transaction (unless of course you use BEGIN/COMMIT explicitly). So
"event + trigger" will succeed or fail atomically.
-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm. -Dylan
From | Date | Subject | |
---|---|---|---|
Next Message | Command Prompt, Inc. | 2001-09-17 21:04:13 | Practical Cursors |
Previous Message | Martín Marqués | 2001-09-17 20:49:50 | Re: locale and spanish acute |