Skip site navigation (1) Skip section navigation (2)

Re: pgadmin error

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: (view raw, whole thread or download thread mbox)
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
Twitter: @pgsnake

EnterpriseDB UK:
The Enterprise PostgreSQL Company

In response to


pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2012-05-16 18:54:25
Subject: Re: [ANNOUNCE] pgAdmin v.1.16.0 Beta 1 now available
Previous:From: Guillaume LelargeDate: 2012-05-16 17:28:00
Subject: Re: Windows and Mac OS X packages for beta

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group