Re: Is that normal I can't commit a transaction when using refcursor in a stored procedure

David Gagnon <dgagnon@siunik.com> writes:
> CREATE TEMP TABLE T_AUX (
> ...
> ) ON COMMIT DROP'';

> WARN [http8080-Processor4] (DbConnection.java:218) 2005-03-22
> 13:51:55,359 : DB: Error commiting Transaction: ERROR: relation 6013057
> is still open

Is this temp table used in your cursor?  If so this is a recently-fixed
server bug ("recent" = 7.4.7 and later, I think).  It was trying to drop
ON COMMIT DROP tables before closing cursors...

            regards, tom lane