Re: Does the block of code in a stored procedure execute as a transaction? - Mailing list pgsql-general

From
Subject Re: Does the block of code in a stored procedure execute as a transaction?
Date
Msg-id 65238.66.212.203.144.1059532500.squirrel@$HOSTNAME
Whole thread Raw
In response to Re: Does the block of code in a stored procedure execute as a transaction?  (Freddy Menjívar M. <mmfreddy@hotmail.com>)
List 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




pgsql-general by date:

Previous
From: fixed
Date:
Subject: Auto-increment not really working
Next
From:
Date:
Subject: Re: Does the block of code in a stored procedure execute as a transaction?