| From: | "Shujun Huang" <shujun(dot)huang(at)noaa(dot)gov> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1482: SQL ERROR IN 7.4.7 |
| Date: | 2005-02-14 13:37:23 |
| Message-ID: | 20050214133723.0D110F0AC6@svr2.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1482
Logged by: Shujun Huang
Email address: shujun(dot)huang(at)noaa(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Plohn | 2005-02-14 14:28:37 | Bug #1451 |
| Previous Message | Alexander M. Pravking | 2005-02-14 12:10:13 | ROLLBACK of SET TimeZone |