BUG #1482: SQL ERROR IN 7.4.7

The following bug has been logged online:

Bug reference:      1482
Logged by:          Shujun Huang
Email address:      shujun.huang@noaa.gov
PostgreSQL version: 7.4.7
Operating system:   RHEL3
Description:        SQL ERROR IN 7.4.7
Details:

RENCENTLY I RAN INTO THIS ERROR CODE 25P01 WHICH IS "NO ACTIVE SQL
TRNASACTION". THE POSTMASTER IS RUNNING OK. THIS HAPPENED AFTER WE UPGRADED
FROM 7.4.6 TO 7.4.7.
ANY INSERT/UPDATE QUERY RUNS OK, A SIMPLE RETRIEVE QUERY IS ALSO RUNNING OK,
ANY RETRIEVE QUERIES INVOLVE IN CURSOR FETCHING IS NOT WORKING.
IT GIVES ABOVE ERROR. IF THERE ARE MORE THAN ONE COURSORS IN A ROUTINE, THE
ERROR CODE IS 34000 WHICH SAYS "IHVALID CURSOR NAME".
ANY IDEA WHAT WAS WRONG?