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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Gagnon <dgagnon(at)siunik(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Is that normal I can't commit a transaction when using refcursor in a stored procedure
Date: 2005-03-22 19:28:16
Message-ID: 11227.1111519696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

David Gagnon <dgagnon(at)siunik(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Gagnon 2005-03-22 20:26:31 Re: Is that normal I can't commit a transaction when using
Previous Message David Gagnon 2005-03-22 19:08:07 Is that normal I can't commit a transaction when using refcursor in a stored procedure