Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-11-04 Thread Dave Cramer
Hi Ian, Thanks, will do Dave Cramer On Thu, 3 Nov 2022 at 21:36, Ian Lawrence Barwick wrote: > 2022年9月6日(火) 21:32 Dave Cramer : > > > > > > > > > > On Tue, 6 Sept 2022 at 02:30, Ibrar Ahmed wrote: > >> > >> > >> > >> On Fri, Aug 12, 2022 at 5:48 PM Dave Cramer > wrote: > >>> > >>> > >>> >

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-11-03 Thread Ian Lawrence Barwick
2022年9月6日(火) 21:32 Dave Cramer : > > > > > On Tue, 6 Sept 2022 at 02:30, Ibrar Ahmed wrote: >> >> >> >> On Fri, Aug 12, 2022 at 5:48 PM Dave Cramer wrote: >>> >>> >>> >>> On Fri, 5 Aug 2022 at 17:51, Justin Pryzby wrote: On Tue, Jul 26, 2022 at 08:11:04AM -0400, Dave Cramer wrote:

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-10-12 Thread Dave Cramer
Waiting on the author to do what ? I'm waiting for a review.

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-09-06 Thread Dave Cramer
On Tue, 6 Sept 2022 at 02:30, Ibrar Ahmed wrote: > > > On Fri, Aug 12, 2022 at 5:48 PM Dave Cramer wrote: > >> >> >> On Fri, 5 Aug 2022 at 17:51, Justin Pryzby wrote: >> >>> On Tue, Jul 26, 2022 at 08:11:04AM -0400, Dave Cramer wrote: >>> > Attached patch to correct these deficiencies. >>> >>>

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-09-06 Thread Ibrar Ahmed
On Fri, Aug 12, 2022 at 5:48 PM Dave Cramer wrote: > > > On Fri, 5 Aug 2022 at 17:51, Justin Pryzby wrote: > >> On Tue, Jul 26, 2022 at 08:11:04AM -0400, Dave Cramer wrote: >> > Attached patch to correct these deficiencies. >> >> You sent a patch to be applied on top of the first patch, but

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-08-12 Thread Dave Cramer
On Fri, 5 Aug 2022 at 17:51, Justin Pryzby wrote: > On Tue, Jul 26, 2022 at 08:11:04AM -0400, Dave Cramer wrote: > > Attached patch to correct these deficiencies. > > You sent a patch to be applied on top of the first patch, but cfbot doesn't > know that, so it says the patch doesn't apply. >

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-08-05 Thread Justin Pryzby
On Tue, Jul 26, 2022 at 08:11:04AM -0400, Dave Cramer wrote: > Attached patch to correct these deficiencies. You sent a patch to be applied on top of the first patch, but cfbot doesn't know that, so it says the patch doesn't apply. http://cfbot.cputube.org/dave-cramer.html BTW, a previous

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-26 Thread Dave Cramer
Hi Sehrope, On Mon, 25 Jul 2022 at 17:53, Dave Cramer wrote: > Hi Sehrope, > > > On Mon, 25 Jul 2022 at 17:22, Sehrope Sarkuni wrote: > >> Idea here makes sense and I've seen this brought up repeatedly on the >> JDBC lists. >> >> Does the driver need to be aware that this SET command was

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-25 Thread Dave Cramer
Hi Sehrope, On Mon, 25 Jul 2022 at 17:22, Sehrope Sarkuni wrote: > Idea here makes sense and I've seen this brought up repeatedly on the JDBC > lists. > > Does the driver need to be aware that this SET command was executed? I'm > wondering what happens if an end user executes this with an OID

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-25 Thread Sehrope Sarkuni
Idea here makes sense and I've seen this brought up repeatedly on the JDBC lists. Does the driver need to be aware that this SET command was executed? I'm wondering what happens if an end user executes this with an OID the driver does not actually know how to handle. > + Oid *tmpOids =

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-25 Thread Joe Conway
On 7/25/22 10:07, Jack Christensen wrote: The advantage is to be able to use the binary format with only a single network round trip in cases where prepared statements are not possible. e.g. when using PgBouncer. Using the simple protocol with this patch lets users of pgx (the Go driver

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-25 Thread Jack Christensen
On Mon, Jul 25, 2022 at 4:57 AM Dave Cramer wrote: > > Dave Cramer > > > On Sun, 24 Jul 2022 at 23:02, Kyotaro Horiguchi > wrote: > >> At Fri, 22 Jul 2022 11:00:18 -0400, Dave Cramer >> wrote in >> > As a proof of concept I provide the attached patch which implements the >> > ability to

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-25 Thread Dave Cramer
Dave Cramer On Sun, 24 Jul 2022 at 23:02, Kyotaro Horiguchi wrote: > At Fri, 22 Jul 2022 11:00:18 -0400, Dave Cramer > wrote in > > As a proof of concept I provide the attached patch which implements the > > ability to specify which oids will be returned in binary format per > > session. >

Re: Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-24 Thread Kyotaro Horiguchi
At Fri, 22 Jul 2022 11:00:18 -0400, Dave Cramer wrote in > As a proof of concept I provide the attached patch which implements the > ability to specify which oids will be returned in binary format per > session. ... > Both the JDBC driver and the go driver can exploit this change with no >

Proposal to provide the facility to set binary format output for specific OID's per session

2022-07-22 Thread Dave Cramer
Greetings, Jack Christensen the author of the go pgx driver had suggested Default result formats should be settable per session · Discussion #5 · postgresql-interfaces/enhancement-ideas (github.com) The JDBC driver has a