Re: [HACKERS] JDBC behaviour

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>, PostgreSQL-hackers <pgsql-hackers(at)postgresql(dot)org>, List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [HACKERS] JDBC behaviour
Date: 2016-02-24 02:14:50
Message-ID: CAMsr+YGsgSCE-jzVZY47ufW5ZXz8TRW42NKZtkHQ39s4P2PExQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc

On 23 February 2016 at 22:46, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Craig Ringer <craig(at)2ndquadrant(dot)com> writes:
> > On 23 February 2016 at 21:34, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> >> I believe Sridhar is imagining that someday "set autocommit to false"
> >> might be a command that the server would understand.
>
> > ... I guess. Yeah.
>
> We've been there, we've done that. We're not doing it again.
>

Thanks for the pointer to the history.

I had zero enthusiasm for going that way anyway and was mostly trying to
figure out what Sridhar was talking about. It's useful to know it's already
been explored though.

I think we know where we need to go from here - updating that PgJDBC patch
to add a connection option, making sure it doesn't add round-trips, adding
tests and merging it. At this point it's up to Sridhar to start putting
time and development effort into it to push it forward if desired.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2016-02-24 04:39:35 Re: PostgreSQL flavors
Previous Message Magnus Hagander 2016-02-24 01:49:50 Re: PostgreSQL flavors

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2016-02-24 02:19:23 Re: The plan for FDW-based sharding
Previous Message Tomas Vondra 2016-02-24 01:43:14 Re: Add generate_series(date,date) and generate_series(date,date,integer)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Raj Gandhi 2016-02-25 16:11:47 support for Unix Domain socket
Previous Message Tom Lane 2016-02-23 14:46:53 Re: [HACKERS] JDBC behaviour