From: | "Tobias Wendorff" <tobias(dot)wendorff(at)tu-dortmund(dot)de> |
---|---|
To: | "Jan Wieck" <jan(at)wi3ck(dot)info> |
Cc: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>, pgsql-odbc(at)lists(dot)postgresql(dot)org |
Subject: | Re: NUMERIC type makes trouble in MS Access |
Date: | 2018-05-27 21:43:31 |
Message-ID: | 501898191bb8dd726b4df9434b93071c.squirrel@webmail.tu-dortmund.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Dear Jan,
Am So, 27.05.2018, 23:22 schrieb Jan Wieck:
>
> Nope, please read that again and then compare that statement to
> what you wrote about the "commercial" driver (using double) and
> your suggestion to have a switch to make the PostgreSQL ODBC
> driver do the same (nonsense).
I'm asking you not to be condescending with people who come to
this mailing list with a problem. Not all the members on this
lists senior postgres architects, some are just normal users.
My idea for this "nonsense" switch just was a workaround for bad
designed databases schemas or for compatibility reasons with rarely
used closed source applications, such as Microsoft Access.
> But what precision does Access claim to support?
Access 2010 at least can handle a precision of 28 digits.
Actually, that's what you can set on its GUI.
> All I understood so far is that PostgreSQL's NUMERIC without explicit
> precision sometimes overwhelms Access with too many digits after the
> decimal point. If that is accurate you may want to either complain to
> Microsoft about their insufficient implementation of DECIMAL or fix
> the schema of the source database.
I don't think that the database design is broken, since PostgreSQL
supports NUMERIC columns without a specific precision. So all I can
do is: create a VIEW, which rounds or casts my data on the fly to
a format, Access can access via the ODBC driver.
Best regards,
Tobias
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2018-05-28 01:34:09 | Re: NUMERIC type makes trouble in MS Access |
Previous Message | Jan Wieck | 2018-05-27 21:22:21 | Re: NUMERIC type makes trouble in MS Access |