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
On 09/14/2013 08:51 AM, Kevin Grittner wrote:
Adrian Klaver wrote:
create table float_test (id int, f_fld double precision);
insert into float_test values (1, 6.31);
insert into float_test values (2, 6.32);
select * from float_test ;
id | f_fld
+---
1 | 6.31
2 | 6.32
(
Adrian Klaver wrote:
> create table float_test (id int, f_fld double precision);
> insert into float_test values (1, 6.31);
> insert into float_test values (2, 6.32);
> select * from float_test ;
>
> id | f_fld
> +---
> 1 | 6.31
> 2 | 6.32
> (2 rows)
If, instead of those insert
On 09/13/2013 12:36 PM, Joanne Salerno - NOAA Federal wrote:
Arian,
It is a single database . Postgres was upgraded from 8.2.6 to 9.2.4...
the database contents was not altered in upgrade, that is a 8.2.6 dump
was not created then uploaded to 9.2.4.
Perhaps handling of double precision, changed
On 09/13/2013 12:36 PM, Joanne Salerno - NOAA Federal wrote:
Arian,
It is a single database . Postgres was upgraded from 8.2.6 to 9.2.4...
the database contents was not altered in upgrade, that is a 8.2.6 dump
was not created then uploaded to 9.2.4.
So you used pg_upgrade to move the data?
If
Arian,
It is a single database . Postgres was upgraded from 8.2.6 to 9.2.4... the
database contents was not altered in upgrade, that is a 8.2.6 dump was not
created then uploaded to 9.2.4.
Perhaps handling of double precision, changed from 8.2.6 to 9.2.4 ?
Joanne
On Fri, Sep 13, 2013 at 11:40
On 09/13/2013 11:32 AM, NWRFC Portland wrote:
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 def
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
