Re: dblink generates orphaned connections

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tatsuhito Kasahara <kasahara(dot)tatsuhito(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: dblink generates orphaned connections
Date: 2009-09-12 23:22:32
Message-ID: 4AAC2D38.4020306@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tatsuhito Kasahara wrote:
> dblink generates orphaned connections when we failed on performing dblink() function.
> # But it occurs only when dblink('conn_str', 'sql', true). See following examples.

> I think that the dblink should not ereport() before PQfinish(conn) in
> dblink_record_internal() when we use temporary connection.

Thanks for the report. Patch applied to HEAD and 8.4 branch. Problem
introduced in 8.4

Joe

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message aoyogi kouhei 2009-09-13 00:04:04 Re: BUG #5050: text to timestamp failure
Previous Message the6campbells 2009-09-12 23:13:41 BUG #5051: SQLNumResultCols returns 0 for common table expression