Re: Does the block of code in a stored procedure execute as a transaction?

From: <btober(at)seaworthysys(dot)com>
To: <mmfreddy(at)hotmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does the block of code in a stored procedure execute as a transaction?
Date: 2003-07-30 02:35:00
Message-ID: 65238.66.212.203.144.1059532500.squirrel@$HOSTNAME
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> NO,
> Functions and triggers doesn't start any transaction,
> it must be in a upper-level transaction, this since Postgresql
> doesn'n support nested transactions.
>
> therefore it is unsafe in multi-user enviroments :(

Thank you. But so how can I do this. Can I add a BEGIN TRANSACTION ...
COMMIT block around the call to my sequence-updater procedure inside the
trigger which invokes it?

~Berend Tober

In response to

Browse pgsql-general by date

  From Date Subject
Next Message btober 2003-07-30 02:44:42 Re: Does the block of code in a stored procedure execute as a transaction?
Previous Message fixed 2003-07-30 01:36:03 Auto-increment not really working