I have a problem with postgres freeing resouces.
Consider the following routine.
int foo()
{
PgDatabase *pDatabase = new PgDatabase(cpDBName);
// Use the connection, insert a record etc.
delete pDatabase;
}
The delete call does not cause system resources to be freed, such
as the socket connection. If you call this function about 1010 times,
postgres will fail, stating that there are no system resources, too
many open files.
I am using postgrex 6.x
Thanks