postgresql

Find missing rows using SQL

I have an SQL table as such name | engins| frank ---------------------------+-------+------ John Smith | 8422| 854 (1 rows) And need to make a query such that only return the row john smith when engins is more than 2000 ...

Async queries with DBD::Pg fail with: Cannot execute until previous async query has finished

Hello, I'm using CentOS 5.5 Linux (same as Redhat 5.5) with stock perl v5.8.8 and have installed DBD-Pg-2.17.1 via CPAN shell and I'm using postgresql-server-8.4.5-1PGDG.rhel5 and friends. I have prepared a simple test case demonstrating my problem - it is listed at the bottom. My code works ok, when I remove {pg_async => PG_ASYNC} M...