Re: dblink generates orphaned connections - Mailing list pgsql-bugs

From Joe Conway
Subject Re: dblink generates orphaned connections
Date
Msg-id 4AAC2D38.4020306@joeconway.com
Whole thread Raw
In response to dblink generates orphaned connections  (Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp>)
List 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

pgsql-bugs by date:

Previous
From: "the6campbells"
Date:
Subject: BUG #5051: SQLNumResultCols returns 0 for common table expression
Next
From: aoyogi kouhei
Date:
Subject: Re: BUG #5050: text to timestamp failure