8.0 incompatibility - Mailing list pgsql-bugs

From Gaetano Mendola
Subject 8.0 incompatibility
Date
Msg-id cho04j$860$1@floppy.pyrenet.fr
Whole thread Raw
List pgsql-bugs
Hi all,
I'm observing that this piece of code doesn't work
anymore in postgres 8.0

  DECLARE
     quota  RECORD;
  BEGIN
     FOR quota IN
        SELECT quota
        FROM foo
     LOOP
        ....
     END LOOP;
  ....

the table foo have the field quota

The error reported is:

ERROR:  record "quota" is not assigned yet
DETAIL:  The tuple structure of a not-yet-assigned record is indeterminate.

and is clear to me why. Shall not this be inserted in the release note ?



Regards
Gaetano Mendola

pgsql-bugs by date:

Previous
From: Kjetil Torgrim Homme
Date:
Subject: Re: PosgreSQL is crashing with a signal 11 - Bug?
Next
From: Michael Fuhr
Date:
Subject: Build failure: TIMEZONE_GLOBAL undeclared