| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Mihai Gheorghiu <tanethq(at)earthlink(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Transaction |
| Date: | 2001-09-17 19:57:03 |
| Message-ID: | Pine.BSF.4.21.0109171255440.59052-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mike | 2001-09-17 20:00:25 | Re: Error in compiling PHP with PostgreSQL support |
| Previous Message | Tom Lane | 2001-09-17 19:39:43 | Re: [GENERAL] pg_dump error - LOCALIZATION PROBLEM |