Re: Re: perl use of cursors and fetch forward

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Frank <jrf(at)segovia(dot)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: perl use of cursors and fetch forward
Date: 2001-01-29 17:17:18
Message-ID: 25060.980788638@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Frank <jrf(at)segovia(dot)mit(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-29 17:35:13 Re: Trouble porting postgreSQL to WinNT
Previous Message Konstantinos Agouros 2001-01-29 16:57:18 plpgsql-function returning a table?