Re: Dblink and ISDN

Rod Taylor wrote:
> Out of curiousity, what happens if the remove server is unavailable?
>

I tried it against a bogus IP, and this is what I got:

test=# select dblink_tok(t1.dblink_p,0) as f1, dblink_tok(t1.dblink_p,1)
as f2 from (select dblink('hostaddr=123.45.67.8
dbname=template1','select proname, prosrc from pg_proc WHERE proname
LIKE ''bytea%''') as dblink_p) as t1;
ERROR: dblink: connection error: could not connect to server:
Connection timed out
Is the server running on host 123.45.67.8 and accepting
TCP/IP connections on port 5432?

test=#

dblink just uses libpq to make a client connection, and thus inherits
libpq's response.

Joe