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:[EMAIL PROTECTED]] > Sent: Monday, January 15, 2001 9:32 AM > To: Belcher, Jim > Cc: '[EMAIL PROTECTED]' > 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 > [EMAIL PROTECTED] | (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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
