Re: [GENERAL] JDBC Postgres problem

2010-07-09 Thread Craig Ringer
On 09/07/10 21:36, Tyler Hains wrote: >> We are having a very strange issue where for certain records, queries >> sent via JDBC return no results when the identical query via command >> line or pgadmin return non-null (expected) results. Example below. We >> are running 8.3.9. > > We found our pro

Re: [GENERAL] JDBC Postgres problem

2010-07-09 Thread Tyler Hains
> We are having a very strange issue where for certain records, queries > sent via JDBC return no results when the identical query via command > line or pgadmin return non-null (expected) results. Example below. We > are running 8.3.9. We found our problem. It turned out to be a config file that w

Re: [GENERAL] JDBC Postgres problem

2010-07-08 Thread Craig Ringer
On 9/07/2010 5:24 AM, Tyler Hains wrote: We are having a very strange issue where for certain records, queries sent via JDBC return no results when the identical query via command line or pgadmin return non-null (expected) results. Example below. We are running 8.3.9. Can you post a compilable,

[GENERAL] JDBC Postgres problem

2010-07-08 Thread Tyler Hains
We are having a very strange issue where for certain records, queries sent via JDBC return no results when the identical query via command line or pgadmin return non-null (expected) results. Example below. We are running 8.3.9. >> SELECT client_id FROM locations WHERE external_id = '278'; >>