"Gnanakumar" <gnanam(at)zoniac(dot)com> wrote:
> We're using PostgreSQL v8.2.3.
There are probably hundreds of bug fixes between 8.2.3 and the
current 8.2 release, which is 8.2.21.
http://www.postgresql.org/support/versioning
http://www.postgresql.org/docs/8.2/static/release.html
On top of that, 8.2 is so old that it's three months away from the
end of its five-year support window:
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy
I recommend that you apply the 8.2 bug fixes immediately, and start
working on a plan to move to 9.0. If you see the problem in a
version which is current and supported, please post again.
-Kevin