[GENERAL] Postgres 9.2.4 "Double Precision" Precision

2013-09-13 Thread NWRFC Portland
I recently upgraded from postgres 8.2.6 to 9.2.4 . For the most part I am enjoying the upgrade. I have found one behavior that I can not explain. Below is sample contents of a table. "VALUE" in column 7 is defined as double precision (table definition is the same in 8.2.6 as 9.2.4). The chan

Re: [GENERAL] Postgres 9.2.4 "Double Precision" Precision

2013-09-16 Thread NWRFC Portland
Adrian, Kevin, Thank you for the clues. It turns out a java process was added (between the data source and database) at same time of postgres upgrade. It was the java process that incorrectly handled the double precision data. Joanne On Sat, Sep 14, 2013 at 9:57 AM, Adrian Klaver wrote: > On