Re: View using dblink fails if not able to make connection

Поиск

Список

Период

Сортировка

От	George Weaver
Тема	Re: View using dblink fails if not able to make connection
Дата	10 ноября 2012 г. 14:04:45
Msg-id	964AD18AD25241BFA778E102A5BD0D17@D420 обсуждение
Ответ на	View using dblink fails if not able to make connection ("George Weaver" <gweaver@shaw.ca>)
Список	pgsql-general

Дерево обсуждения

----- Original Message -----
From: Igor Romanchenko

>On Fri, Nov 9, 2012 at 9:21 PM, George Weaver <gweaver@shaw.ca> wrote:

>>Hi Everyone,

>>I have a view made up of a local query unioned with a view comprised of a dblink query.

>>If the dblink query cannot establish a connection, I get the "could not connect to server" error and the whole view fails.

>>Setting fail_on_error to false does not work in this situation.

>>Is there any way to test the connection inside the view when the view is called and either return the whole view or just the local component if a dblink connection cannot be made?

>>Thanks,
>>George

>Hi.
>You can put you dblink query into PL/pgSQL function that:
>1) Will return dblink result, if no errors occurred.
>2) Will return no rows, if error occured

>Then just use this function in the union.

Hi Igor,

I'll look at that!

Thanks,

George

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: View using dblink fails if not able to make connection