Re: [GENERAL] Binary params in libpq

2011-03-01 Thread Tom Lane
Kelly Burkhart writes: > On Mon, Feb 28, 2011 at 8:42 AM, Merlin Moncure wrote: >> Actually, this has always been a compile time option on the server as >> far as i remember and there is protocol support for it -- libpq tells >> you how it has been set...you've always had to deal with this > I d

Re: [GENERAL] Binary params in libpq

2011-03-01 Thread Merlin Moncure
On Tue, Mar 1, 2011 at 8:19 AM, Kelly Burkhart wrote: > On Mon, Feb 28, 2011 at 8:42 AM, Merlin Moncure wrote: >> On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer >>> AFAIK, the `timestamp' type moved from a floating-point to an integer >>> representation internally, which would've affected the bina

Re: [GENERAL] Binary params in libpq

2011-03-01 Thread Kelly Burkhart
On Mon, Feb 28, 2011 at 8:42 AM, Merlin Moncure wrote: > On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer >> AFAIK, the `timestamp' type moved from a floating-point to an integer >> representation internally, which would've affected the binary protocol >> representation. That was even a compile-time

Re: [GENERAL] Binary params in libpq

2011-02-28 Thread Craig Ringer
On 28/02/2011 10:42 PM, Merlin Moncure wrote: Actually, this has always been a compile time option on the server as far as i remember and there is protocol support for it -- libpq tells you how it has been set...you've always had to deal with this (libpqtypes, which I've mentioned several times

Re: [GENERAL] Binary params in libpq

2011-02-28 Thread Daniele Varrazzo
On Mon, Feb 28, 2011 at 2:42 PM, Merlin Moncure wrote: > On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer >> AFAIK, the `timestamp' type moved from a floating-point to an integer >> representation internally, which would've affected the binary protocol >> representation. That was even a compile-time

Re: [GENERAL] Binary params in libpq

2011-02-28 Thread Merlin Moncure
On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer wrote: > On 28/02/2011 7:48 AM, Merlin Moncure wrote: > >>> How stable is the binary representation for the PostgreSQL types? We >>> may just pass bytea data in binary format and pass everything else as >>> text parameters, or pass different types too

Re: [GENERAL] Binary params in libpq

2011-02-27 Thread Craig Ringer
On 28/02/2011 7:48 AM, Merlin Moncure wrote: How stable is the binary representation for the PostgreSQL types? We may just pass bytea data in binary format and pass everything else as text parameters, or pass different types too as binary, if performace would benefit. Did binary format ever chan

Re: [GENERAL] Binary params in libpq

2011-02-27 Thread Merlin Moncure
On Sun, Feb 27, 2011 at 1:13 PM, Daniele Varrazzo wrote: > Hello, > > I'm thinking about adding support for PQexecParams and PQprepare in > Psycopg. I've posted more details yesterday on the Psycopg mailing > list . I > have a few prelim

[GENERAL] Binary params in libpq

2011-02-27 Thread Daniele Varrazzo
Hello, I'm thinking about adding support for PQexecParams and PQprepare in Psycopg. I've posted more details yesterday on the Psycopg mailing list . I have a few preliminary questions: How stable is the binary representation for the Pos