Re: v3 from the ground up - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: v3 from the ground up
Date
Msg-id 9506.1083379383@sss.pgh.pa.us
Whole thread Raw
In response to Re: v3 from the ground up  (Brian Olson <bql@bolson.org>)
List pgsql-jdbc
Brian Olson <bql@bolson.org> writes:
> I've been looking at the PostgreSQL docs on the server-client protocol,
> and it doesn't specify the format of binary parameters. Where would
> that be documented?

Presently you have to look at the sources of the backend's send and recv
functions for each datatype.  (If anyone wants to do the legwork to
transpose that information into an SGML chapter, be my guest...)

> Are the type oid-s guaranteed to be constant between versions?

Nothing's really guaranteed, but in practice the built-in type OIDs do
not change --- for instance type text has had OID 25 since Berkeley days.
You cannot however assume anything about types that are not built-in
(which means predefined in src/include/catalog/pg_type.h).

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Result Set Cursor Patch
Next
From: Oliver Jowett
Date:
Subject: Re: Weird prepared stmt behavior