Re: pgadmin error

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