Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14786: Wrong Precision with money datatype - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] BUG #14786: Wrong Precision with money datatype
Date
Msg-id CAKFQuwbRFwNbu6ve39vNzaQ=Mdy-c_sfHV8JO75URNGs-+N9ag@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14786: Wrong Precision with money datatype  (nithinkrishna.p@gmail.com)
List pgsql-bugs
Tree view
On Mon, Aug 21, 2017 at 1:04 AM, <nithinkrishna.p@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      14786
Logged by:          Nithin Krishna
Email address:      nithinkrishna.p@gmail.com
PostgreSQL version: 9.4.5
Operating system:   Windows 2008 R2 Standard Edition
Description:

Hi,

I have a table created in postgres database with money datatype. I have
connected to the database via SQuirrel SQL Client and found that the
precision of the money datatype is shown as 2147483647. But from the
postgres documentation the precision and scale should be 19 and 2
respectively. I am using postgres driver jar postgresql-9.4-1203.jdbc42.jar
and database version is 9.4.5

How/where did you observe this 2147483647 number?​

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14787: Postgresql_for_odoo
Next
From: 691525127@qq.com
Date:
Subject: [BUGS] BUG #14789: In Cascading Replication，the "wal_level" is setted to "archive",the operation becomes abnomal