Postgres Pro
Downloads
Home   >   mailing lists

Re: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit
Date
Msg-id db471ace0909231127t6d69de47l17c9231f1a02ea46@mail.gmail.com
Whole thread Raw
In response to Re: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hi Tom,


> What PG version is this?  8.4 has a connection leak in some cases:
> http://archives.postgresql.org/pgsql-committers/2009-09/msg00125.php
>
> This fix hasn't made any released version yet, but you could apply the
> source patch shown there.

This is 8.4.0 on Windows. Looks like it's the bug you mention. I guess
I'll just upgrade to 8.4.1.

Thanks,
Peter Geoghegan

pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: Source for CreatedSharedMemoryAndSemaphores
Next
From: Bryan Montgomery
Date:
Subject: Looking for way to replicate master db to multiple mobile databases