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 from 8.2.6 to 9.2.4 ?
To follow up, I don't think that is the case. By way of example, granted
on a 9.3 instance:
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)
A couple of questions:
How is the data entered into the database?
Just wondering if there was any client side changes along with the
database change?
Joanne
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
