Search Postgresql Archives

View using dblink fails if not able to make connection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
 
 
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux