From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Charlie Holleran <charles(dot)holleran(at)shiftenergy(dot)com> |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: pgadmin error |
Date: | 2012-05-16 17:51:54 |
Message-ID: | CA+OCxoz=nFC6cyydyH-haCru70C97+rgnHoBLC1fzEbht22QCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
On Wed, May 16, 2012 at 10:04 AM, Charlie Holleran
<charles(dot)holleran(at)shiftenergy(dot)com> wrote:
> Is there a way to configure the JDBC driver that pgadmin uses to access the
> db's? I'm using pg's postgresql-8.4-701.jdbc4.jar in my code and I get the
> correct values from the db. But pgadmin does not get the correct values
> back. pgadmin is rounding real's to 6 significant digits, independent of
> the magnitude of the value. real's obviously have an issue with resolution
> as the magnitude of the number increases. But this pgadmin issue is not
> magnitude dependent. Second the real datatype issue loses resolution in
> power of 2's. pgadmin is losing in the power of 10's. It seems like a
> string parsing issue in the jdbc that only parses the first 6 digits.
>
> So I'd like to configure pgadmin to use the same jdbc driver as my code.
> Which works. Where can I set the driver for pgadmin?
pgAdmin isn't a Java app. It's written in C++ and uses libpq to access
the server.
Where in pgAdmin do you see the rounding? (query tool, edit grid
or...). Can you provide a self contained test case?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-05-16 18:54:25 | Re: [ANNOUNCE] pgAdmin v.1.16.0 Beta 1 now available |
Previous Message | Guillaume Lelarge | 2012-05-16 17:28:00 | Re: Windows and Mac OS X packages for beta |