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

> 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