DBlink extension and behavior of dblink_get_connections()

From: Pankaj Gupta <PGupta(at)vitechinc(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: DBlink extension and behavior of dblink_get_connections()
Date: 2022-04-11 13:00:57
Message-ID: CO6PR02MB7843C3216E2D584D5417DA2FD3EA9@CO6PR02MB7843.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am using dblink extension and getting connection name using dblink_get_connections() function if it do not return specified name then establishing a new connection and if it return then using same connection. But there is one weird behaviour, if someone killed session then dblink_get_connections() function still returning connection name in that session and my dblink.exec error out.

Regards,
Pankaj Gupta

This e-mail message and any files transmitted with it may contain confidential and proprietary information and are intended solely for the use of the individual or entity to which they are addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this e-mail in error please notify the sender by reply email and destroy all copies of the original message. Thank you for your cooperation.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-04-11 14:20:06 Re: PostgreSQL : error hint for LATERAL join
Previous Message Euler Taveira 2022-04-11 12:46:06 Re: Support logical replication of DDLs