On Wed, May 16, 2012 at 10:04 AM, Charlie Holleran <charles.holle...@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 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
