Thread: 8.0 incompatibility

8.0 incompatibility

From
Gaetano Mendola
Date:
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