Re: [BUGS] BUG #14526: no unique or exclusion constraint matching the ON CONFLICT - Mailing list pgsql-bugs

From Tiago Babo
Subject Re: [BUGS] BUG #14526: no unique or exclusion constraint matching the ON CONFLICT
Date
Msg-id 549DAB22-678B-47B7-A115-4F4F4E3B4513@gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14526: no unique or exclusion constraint matchingthe ON CONFLICT  (David Gould <daveg@sonic.net>)
List pgsql-bugs
Yes, you're right. I'm using parameters for that part of the query.

> On 9 Feb 2017, at 02:00, David Gould <daveg@sonic.net> wrote:
> 
> On Wed, 08 Feb 2017 18:57:16 -0500
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
>> David Gould <daveg@sonic.net> writes:
>>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>>> You should turn on log_statements and look to see what's actually being
>>>> sent to the server.
>> 
>>> Last time I looked, the JDBC driver always uses prepared statements.
>> 
>> Yeah, but does JDBC actually pull literal constants out of the query
>> string and send them as separate parameter values?  That seems like a
>> pretty dumb idea.
> 
> I'm guessing that the actual call from Scala uses parameters for this
> part instead of duplicating the same query with only the qualification
> changing.
> 
> Tiago, can you show us the actual code that runs this statement?
> 
> -dg
> 
> -- 
> David Gould              510 282 0869         daveg@sonic.net
> If simplicity worked, the world would be overrun with insects.


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: [BUGS] BUG #14530: Logical Decoding Slowness
Next
From: Devrim Gündüz
Date:
Subject: Re: [BUGS] BUG #14536: Centos 7 gdal-libs Dependency Problem