Re: SQL-Invoked Procedures for 8.1

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL-Invoked Procedures for 8.1
Date: 2004-09-23 21:10:30
Message-ID: 877jqkbsjd.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:

> What's needed for this is to isolate the transaction-initiating code
> from the main query-processing loop. So for CALL statements it wouldn't
> be invoked, and the procedure would be able to use its own explicit
> transaction blocks and savepoints.

Is that really needed? What if the procedure starts in a transaction normally
but is just allowed to commit it and start another transaction? I mean it's
not like it would be allowed to do any actual work without starting a
transaction anyways.

--
greg

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dominic Mitchell 2004-09-23 21:11:58 Re: doc patch for ssl in server
Previous Message Oliver Jowett 2004-09-23 21:03:03 Re: SQL-Invoked Procedures for 8.1