Thank you Tom, I also should have reread the docs on 1) and 2) - it is mentioned there too that you have to call PQfinish and PQclear even on failed operations. Could you explain a bit more, where to get the OIDs? There are really not many PQprepare examples around (I wonder why, isn't it the fastest method?) Regards Alex On 1/28/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Alexander Farber <alexander.farber@xxxxxxxxx> writes: > > 4) How do I set the last PQprepare argument, the const Oid *paramTypes? > > You'd need to look up the OIDs of the parameter types. In practice it's > usally a lot easier to write the queries so that the parameter types can > be inferred by the backend.
