Index size

Guest · Posted: Tue Mar 08, 2005 6:12 pm Post subject: SRF, JDBC and result info

Hi everybody!

I have an SRF which is called from a JAVA app with JDBC. Everything works
fine
and I want now to be able to pass some result-related info to my app. It is
not about the format of the results (ResultSetMetaData) or something like
that.

Is it possible to return some string (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?

http://archives.postgresql.org

Kris Jurka · *nix forums beginner Joined: 01 Mar 2005 Posts: 28

On Tue, 8 Mar 2005 ntinos@aueb.gr wrote:

Guest · Posted: Fri Mar 11, 2005 6:52 am Post subject: Re: 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:

Guest · Posted: Fri Mar 11, 2005 11:17 am Post subject: Re: SRF, JDBC and result info

Solution found! Thanks to Kris Jurka's advise I managed to pass this info
using: elog(INFO,... or elog(NOTICE,... . These messages together with
..getWarnings() do the job. :

e.g. message returned by the SQLWarning:

SNOTICEC00000M#SUCCESSFUL EXECUTION. NO TUPLES FROM PEER(S):
mobileb#Ftestmybuild.cL2558Ranswer

Getting the plain message is then trivial (e.g. using flag chars like '#'
above)

Of cource the appropriate logging must be set in postgresql.conf.

Just in case somenone wants to do the same thing.
I dont know if this is the best solution (or if any other exists) but it
surely works.

Regards,
Ntinos Katsaros

PS: libpq has nothing to do with the above Smile

!

ntinos@aueb.gr writes:

Google