Re: Re: perl use of cursors and fetch forward - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: perl use of cursors and fetch forward
Date
Msg-id 25060.980788638@sss.pgh.pa.us
Whole thread Raw
In response to Re: perl use of cursors and fetch forward  (John Frank <jrf@segovia.mit.edu>)
List pgsql-general
John Frank <jrf@segovia.mit.edu> writes:
> this works if the "begin work;" and "declare ...;" are in separate exec
> requests.

This is fixed for 7.1.  The problem in 7.0 is that the check for "are we
inside a transaction block?" is done at the wrong time, ie, during
initial parsing of the query string ...

            regards, tom lane

pgsql-general by date:

Previous
From: Konstantinos Agouros
Date:
Subject: plpgsql-function returning a table?
Next
From: "Steven Lacroix"
Date:
Subject: Could not flush socket buffer.