Re: Multiple SQL statements within a function...

From: Haroldo Stenger <hstenger(at)adinet(dot)com(dot)uy>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Multiple SQL statements within a function...
Date: 2002-08-01 04:09:45
Message-ID: 1028174986.21143.12.camel@caverna
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

El jue, 01-08-2002 a las 01:06, Tom Lane escribió:
> Yes. The function is necessarily invoked within an interactive query
> (SELECT, UPDATE, or whatever) and that establishes the transaction
> context. The function cannot create a transaction boundary, because
> doing so would break whatever query it was called from.

That will change with nested transactions support, won't it?

Regards

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Boes 2002-08-01 17:26:26 Looking for sanity check on postmaster configuration
Previous Message Tom Lane 2002-08-01 04:06:07 Re: Multiple SQL statements within a function...