Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group