Postgres Pro
Downloads
Home   >   mailing lists

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

From Freddy Menjívar M.
Subject Re: Does the block of code in a stored procedure execute as a transaction?
Date
Msg-id Law10-OE13AMDmZ5fgS0000bfba@hotmail.com
Whole thread Raw
In response to Does the block of code in a stored procedure execute as a transaction?  (<btober@seaworthysys.com>)
Responses Re: Does the block of code in a stored procedure execute as a transaction?  (<btober@seaworthysys.com>)
List pgsql-general
Tree view
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 :(

pgsql-general by date:

Previous
From: Eric Clark
Date:
Subject: Re: truncated string problem
Next
From: Alvaro Herrera
Date:
Subject: Re: truncated string problem