what could be blocking an insertion?

From: Kent Tong <kent(at)cpttm(dot)org(dot)mo>
To: pgsql-general(at)postgresql(dot)org
Subject: what could be blocking an insertion?
Date: 2007-11-05 04:31:35
Message-ID: 13581279.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

A few days ago an insertion operation issued by a JDBC client that was
blocked by
postgreSQL. I could verify that by issuing the operation using psql. My
question is,
what could be causing this? There were other JDBC clients but they never
lock any
tables. They all used transactions with the serializable isolation level. A
day or so
later the problem was gone.

Any idea? I need to prevent it from happening again. Thanks!

-----
--
Kent Tong
Wicket tutorials freely available at http://www.agileskills2.org/EWDW
--
View this message in context: http://www.nabble.com/what-could-be-blocking-an-insertion--tf4749607.html#a13581279
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2007-11-05 06:09:12 Re: Would an index benefit select ... order by?
Previous Message Greg Williamson 2007-11-05 02:32:55 Re: What makes a Postgres DBA?