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