Re: [HACKERS] Dblink and ISDN

2002-04-02 Thread Joe Conway
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

Re: [HACKERS] Dblink and ISDN

2002-04-02 Thread Rod Taylor
Out of curiousity, what happens if the remove server is unavailable? - Original Message - From: "Joe Conway" <[EMAIL PROTECTED]> To: "Darko Prenosil" <[EMAIL PROTECTED]> Cc: "Hackers" <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002

Re: [HACKERS] Dblink and ISDN

2002-04-02 Thread Joe Conway
Joe Conway wrote: > Darko Prenosil wrote: > >> SAMPLE: >> >> create view myremotetable as >> select dblink_tok(t1.dblink_p,0) as f1, dblink_tok(t1.dblink_p,1) as f2 >> from (select dblink('hostaddr=127.0.0.1 port=5432 dbname=template1 >> user=postgres password=postgres' >>

Re: [HACKERS] Dblink and ISDN

2002-04-02 Thread Joe Conway
Darko Prenosil wrote: > SAMPLE: > > create view myremotetable as > select dblink_tok(t1.dblink_p,0) as f1, dblink_tok(t1.dblink_p,1) as f2 > from (select dblink('hostaddr=127.0.0.1 port=5432 dbname=template1 > user=postgres password=postgres' > ,'select proname, prosrc fro

[HACKERS] Dblink and ISDN

2002-04-02 Thread Darko Prenosil
We have a request from our customers to link two database servers through the ISDN link.   We found the dblink in the contrib directory, and it works ,but there is one big problem. I'll try to explain it using the sample from README.dblink:   SAMPLE:  create view myremotetable as select dbl