From: | "George Weaver" <gweaver(at)cleartagsoftware(dot)com> |
---|---|
To: | "Igor Romanchenko" <igor(dot)a(dot)romanchenko(at)gmail(dot)com> |
Cc: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: View using dblink fails if not able to make connection |
Date: | 2012-11-09 21:45:38 |
Message-ID: | 964AD18AD25241BFA778E102A5BD0D17@D420 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- Original Message -----
From: Igor Romanchenko
>On Fri, Nov 9, 2012 at 9:21 PM, George Weaver <gweaver(at)shaw(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2012-11-09 22:02:36 | Re: Revoke "drop database" even for superusers? |
Previous Message | Edson Richter | 2012-11-09 21:35:23 | Re: Revoke "drop database" even for superusers? |