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

2012-11-10 Thread George Weaver
- Original Message - From: Igor Romanchenko >On Fri, Nov 9, 2012 at 9:21 PM, George Weaver 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 >>

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

2012-11-09 Thread Igor Romanchenko
On Fri, Nov 9, 2012 at 9:21 PM, George Weaver 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. >

[GENERAL] View using dblink fails if not able to make connection

2012-11-09 Thread George Weaver
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 th