Re: [HACKERS] [GENERAL] Networking feature for postgresql...

2004-10-16 Thread Joe Conway
Katsaros Kwn/nos wrote: > Having taken a look at the dblink code I have some questions: ISTM that you might start with dblink_record() and modify it to suit using SPI and asynchronous libpq calls. See: http://www.postgresql.org/docs/current/static/libpq-async.html Joe --

Re: [HACKERS] [GENERAL] Networking feature for postgresql...

2004-10-16 Thread Katsaros Kwn/nos
Hi again, Having taken a look at the dblink code I have some questions: Having a user defined function, is it possible -with no serious memory overheads- to fork it (outside SPI calls code) in order to make concurrent dblink calls? What I'm thinking of doing is to create a function which opens an

Re: [HACKERS] [GENERAL] Networking feature for postgresql...

2004-10-14 Thread Richard Huxton
Katsaros Kwn/nos wrote: Well, actually no :) ! Thanks for the hint! But just from curiosity, would the scenario I described work? I mean is it possible for an SPI process to run in the background while other SPI calls are made? I don't think so, you're running in a backend process, so you'd need to

Re: [HACKERS] [GENERAL] Networking feature for postgresql...

2004-10-14 Thread Katsaros Kwn/nos
Well, actually no :) ! Thanks for the hint! But just from curiosity, would the scenario I described work? I mean is it possible for an SPI process to run in the background while other SPI calls are made? Ntinos Katsaros On Thu, 2004-10-14 at 11:15, Richard Huxton wrote: > Katsaros Kwn/nos wrote

Re: [HACKERS] [GENERAL] Networking feature for postgresql...

2004-10-14 Thread Richard Huxton
Katsaros Kwn/nos wrote: Hi, I'm trying to add a -project specific- networking feature to my postgres build (or database as function). What I want to do is to send a Query instance (as a String-retrieved through an SPI function) to other machines and (after they have executed it) to receive result t