Re: [BUGS] BUG #14526: no unique or exclusion constraint matching the ON CONFLICT

Поиск
Список
Период
Сортировка
От Tiago Babo
Тема Re: [BUGS] BUG #14526: no unique or exclusion constraint matching the ON CONFLICT
Дата
Msg-id 549DAB22-678B-47B7-A115-4F4F4E3B4513@gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14526: no unique or exclusion constraint matchingthe ON CONFLICT  (David Gould <daveg@sonic.net>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [BUGS] BUG #14530: Logical Decoding Slowness
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: [BUGS] BUG #14536: Centos 7 gdal-libs Dependency Problem