Re: [GENERAL] SRF, JDBC and result info

exists) but it surely works. Regards, Ntinos Katsaros PS: libpq has nothing to do with the above :-)! [EMAIL PROTECTED] writes: Thank you very much for your reply. The thing is that my SRF is written in C, not plpgsql, but I'll look into RAISE NOTICE anyway.(I think there is something

Re: [GENERAL] SRF, JDBC and result info

Thank you very much for your reply. The thing is that my SRF is written in C, not plpgsql, but I'll look into RAISE NOTICE anyway.(I think there is something equevalent in libpq) Thanks again, Ntinos Katsaros Kris Jurka writes: On Tue, 8 Mar 2005 [EMAIL PROTECTED] wrote: Hi ever

[GENERAL] SRF, JDBC and result info

other type of)info together with the result tuples (even if it requiers some hacking i.e. there is no provision for something like that)? Any ideas? Regards, Ntinos Katsaros ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [GENERAL] Getting table metadata

re relname= Ntinos Katsaros ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] PQisBusy() always returns TRUE

7;m a little confused on its structure. Any pointers? Thanks, Ntinos Katsaros ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] PQisBusy() always returns TRUE

it worked. However, the problem now is that it is slow (surely slower than using blocking commands). If the code above is right (?), why is that? Thanks for your response, Ntinos Katsaros Tom Lane writes: [EMAIL PROTECTED] writes: if (PQconsumeInput(conn)!=1) elog(ERROR,"Err

[GENERAL] PQisBusy() always returns TRUE

e is used inside a SRF that is intended to return tuples from remote dbs (as in dblink). For the time being I query local tables. I use v7.4.2. Is this something too obvious to see it :-) ? Is it something with nonblocking connection establishment? Any suggestions? Thanks in advance, Ntinos Ka

Re: [GENERAL] Can't find relation oid

e tables and SPI to retrieve the Oids ($%&^#$%&!!). When I tried to also retrieve the Oid using libp it worked. I suppose using SPI both to create the tables and retrieve the Oids will be the right solution. I'll try it! Hope this helps, It did help to understand what was g

[GENERAL] Can't find relation oid

k (like in testlibpq.c example in the documentation) but with no result. Maybe the whole process described above runs in a sigle transaction block i.e. that of my SRF(?). I'm a little confused here. Any ideas? Regards, Ntinos Katsaros ---(e