Re: [GENERAL] libpq++

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: "Belcher, Jim" <JBelcher@elastic.com>
Cc: Bugs for PostgreSQL <pgsql-bugs@postgreSQL.org>
Date: 2001-01-17T22:33:53Z
Lists: pgsql-bugs
OK, I can confirm that this is fixed in 7.0.

[ Charset ISO-8859-1 unsupported, converting... ]
> The only problem with this is that we have a product in
> the field using 6.x.  We plan to move to 7 at some point
> but that requires some planning, and major development
> efforts, since more than one product is involved.
> 
> Right now we have corba servers that hold open connections
> to postgres, and we wanted to make them local, and not
> have to mutex them.
> 
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: Monday, January 15, 2001 9:32 AM
> To: Belcher, Jim
> Cc: 'pgsql-general@postgresql.org'
> Subject: Re: [GENERAL] libpq++
> 
> 
> Can you try 7.0.X or 7.1 beta and let us know if it is still a problem?
> 
> [ Charset ISO-8859-1 unsupported, converting... ]
> > 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
> > 
> 
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026