On Wed, May 16, 2012 at 10:04 AM, Charlie Holleran
<charles.holleran@shiftenergy.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