Re: [BUGS] BUG #14786: Wrong Precision with money datatype

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] BUG #14786: Wrong Precision with money datatype
Дата
Msg-id CAKFQuwbRFwNbu6ve39vNzaQ=Mdy-c_sfHV8JO75URNGs-+N9ag@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14786: Wrong Precision with money datatype  (nithinkrishna.p@gmail.com)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14787: Postgresql_for_odoo
Следующее
От: 691525127@qq.com
Дата:
Сообщение: [BUGS] BUG #14789: In Cascading Replication，the "wal_level" is setted to "archive",the operation becomes abnomal