Re: [GENERAL] Postgres 7.2 - Updating rows in cursor problem

Vaclav Kulakovsky <vaclav.kulakovsky@definity.cz> writes:
> I've a problem in PG 7.2. If you update rows which are included in plpgsql
> RECORD , updated rows are again added to the RECORD, so you will get into
> infinite loop.

This is a bug in plgsql, or more precisely in SPI, I think.  The FOR
statement needs to restore its initial value of scanCommandId each time
it resumes execution of the SELECT.  Seems like that should be done down
inside SPI.  Comments?
        regards, tom lane