Re: Is that normal I can't commit a transaction when using

Yes and I am running 7.4.5 so I will update for the fix.

Thanks!
/David
Tom Lane wrote:

>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
>
>
>