Re: Multiple SQL statements within a function... - Mailing list pgsql-admin

From Haroldo Stenger
Subject Re: Multiple SQL statements within a function...
Date
Msg-id 1028174986.21143.12.camel@caverna
Whole thread Raw
In response to Re: Multiple SQL statements within a function...  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple SQL statements within a function...
Next
From: Jeff Boes
Date:
Subject: Looking for sanity check on postmaster configuration