| From: | David Gagnon <dgagnon(at)siunik(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Is that normal I can't commit a transaction when using |
| Date: | 2005-03-22 20:26:31 |
| Message-ID: | 42407F77.70209@siunik.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Yes and I am running 7.4.5 so I will update for the fix.
Thanks!
/David
Tom Lane wrote:
>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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Prasanth | 2005-03-23 19:22:20 | moveToCurrentRow causes ArrayIndexOutOfBoundsException |
| Previous Message | Tom Lane | 2005-03-22 19:28:16 | Re: Is that normal I can't commit a transaction when using refcursor in a stored procedure |