Re: Commit gets locked until vacuum is performed

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-jdbc(at)postgresql(dot)org>, "Xavier Santana" <xsantana(at)slash-solutions(dot)com>
Subject: Re: Commit gets locked until vacuum is performed
Date: 2010-07-12 17:52:20
Message-ID: 4C3B10040200002500033475@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Xavier Santana <xsantana(at)slash-solutions(dot)com> wrote:

> I'm using JDBC driver 8.1-413.jdbc3 to access a PostgreSQL 8.1.3
> database on windows.

Version 8.1.anything is not supported on Windows:

http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

8.1.3 is a very old version of that major release with many known bugs
fixed in later minor releases.

http://www.postgresql.org/support/versioning
http://www.postgresql.org/docs/8.1/static/release.html

The recommended JDBC driver for that PostgreSQL version is 8.4-701:

http://jdbc.postgresql.org/download.html#current

Given what you're running, it's amazing that is your biggest problem.
Please update as soon as possible, at least to 8.2.something-recent.

-Kevin

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2010-07-12 18:30:51 Re: Commit gets locked until vacuum is performed
Previous Message Xavier Santana 2010-07-12 10:49:13 Commit gets locked until vacuum is performed