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

From: Freddy Menjívar M(dot) <mmfreddy(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does the block of code in a stored procedure execute as a transaction?
Date: 2003-07-29 20:47:37
Message-ID: Law10-OE13AMDmZ5fgS0000bfba@hotmail.com
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 :(

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-07-29 20:51:50 Re: truncated string problem
Previous Message Eric Clark 2003-07-29 20:46:36 Re: truncated string problem