DBlink extension and behavior of dblink_get_connections()

Поиск
Список
Период
Сортировка
От Pankaj Gupta
Тема DBlink extension and behavior of dblink_get_connections()
Дата
Msg-id CO6PR02MB7843C3216E2D584D5417DA2FD3EA9@CO6PR02MB7843.namprd02.prod.outlook.com
обсуждение исходный текст
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Mats Taraldsvik
Дата:
Сообщение: Declarative partitioning and partition pruning/check
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL : error hint for LATERAL join