Postgres Pro
Downloads
Home   >   mailing lists

Re: Is that normal I can't commit a transaction when using refcursor in a stored procedure - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Is that normal I can't commit a transaction when using refcursor in a stored procedure
Date
Msg-id 11227.1111519696@sss.pgh.pa.us
Whole thread Raw
In response to Is that normal I can't commit a transaction when using refcursor in a stored procedure  (David Gagnon <dgagnon@siunik.com>)
Responses Re: Is that normal I can't commit a transaction when using
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: David Gagnon
Date:
Subject: Is that normal I can't commit a transaction when using refcursor in a stored procedure
Next
From: David Gagnon
Date:
Subject: Re: Is that normal I can't commit a transaction when using