Re: PL/pgSQL bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/pgSQL bug?
Date
Msg-id 12545.997454818@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL bug?  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
I said:
> SPI is doing CommandCounterIncrements at bizarre times, and in
> particular you get fewer CommandCounterIncrements while planning
> and executing a plpgsql function than you do while re-executing
> an already-planned one.

s/fewer/more/ ... guess I'm not fully awake yet ... but anyway,
SPI's handling of CommandCounterIncrement is certainly broken.
Particularly for cursors --- a CCI for every FETCH will not do,
you want the whole scan to be run with the same commandId.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Null-safe GiST interface (proposal)
Next
From: Tom Lane
Date:
Subject: Re: PL/pgSQL bug?