Re: [GENERAL] SRF, JDBC and result info

2005-03-11 Thread ntinos
) 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 equevalent in libpq

Re: [GENERAL] SRF, JDBC and result info

2005-03-10 Thread ntinos
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 everybody

[GENERAL] SRF, JDBC and result info

2005-03-08 Thread ntinos
(or 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

2005-01-19 Thread ntinos
where relname=table_name Ntinos Katsaros ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] PQisBusy() always returns TRUE

2005-01-15 Thread ntinos
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 Katsaros ---(end of broadcast)--- TIP 8: explain analyze

Re: [GENERAL] PQisBusy() always returns TRUE

2005-01-15 Thread ntinos
this and 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,Error

Re: [GENERAL] PQisBusy() always returns TRUE

2005-01-15 Thread ntinos
on its structure. Any pointers? Thanks, Ntinos Katsaros ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Can't find relation oid

2005-01-03 Thread ntinos
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 ---(end of broadcast