Hello, I'm writing a pl/pgSQL function that connects to multiple PostgreSQL databases and accumulates data from all of them into a temporary table. I use the dblink contrib module to do so. I loop through some records, form a connection string from those records, and do this: PERFORM dblink_connect(conn_str); .... Making many successive calls to this function of mine eventually exhausts the connection limit of my remote DBs (although I think that the default connection limit is something like 5 or 10, and it takes more calls than that). I understood from the dblink docs that calling this particular overload of dblink_connect wouldn't do so, because each subsequent call to it disconnects the last, because an "unnamed connection is opened, replacing any existing unnamed connection". This is unlikely to be a concern in my production system, because users will connect to my main db, execute this function and disconnect (dblink connections only persist for as long as the connection that originated them, I also understand from the docs). Nonetheless, I'd like to know what's happening here. Why the apparent resource leak? Thanks, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
