Re: [JDBC] Problems with Large Objects using Postgres 7.2.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cjwhite(at)cisco(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [JDBC] Problems with Large Objects using Postgres 7.2.1
Date: 2003-04-09 21:31:15
Message-ID: 10160.1049923875@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

"Chris White" <cjwhite(at)cisco(dot)com> writes:
> The first and second are over the same connection. The third is over a
> different connection, but issued after the second transaction has completed.

Oh? At this point I'm prepared to bet that the second transaction isn't
really committed when you think it is. Perhaps the "COMMIT" command
isn't getting flushed out to the backend on time. You might want to
turn on query logging and watch to see exactly what happens when.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris White 2003-04-09 21:41:07 Re: [JDBC] Problems with Large Objects using Postgres 7.2.1
Previous Message Chris White 2003-04-09 21:25:48 Re: [JDBC] Problems with Large Objects using Postgres 7.2.1

Browse pgsql-jdbc by date

  From Date Subject
Next Message Chris White 2003-04-09 21:41:07 Re: [JDBC] Problems with Large Objects using Postgres 7.2.1
Previous Message Barry Lind 2003-04-09 21:29:29 Re: Problems retrieving data from bytea field