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

Поиск
Список
Период
Сортировка
От David Gould
Тема Re: [BUGS] BUG #14526: no unique or exclusion constraint matchingthe ON CONFLICT
Дата
Msg-id 20170208180040.0e2b4891@engels
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14526: no unique or exclusion constraint matching the ON CONFLICT  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [BUGS] BUG #14526: no unique or exclusion constraint matching the ON CONFLICT  (Tiago Babo <tiago.babo@gmail.com>)
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14526: no unique or exclusion constraint matching the ON CONFLICT
Следующее
От: 片本 亘祐(ユニークビジョン)
Дата:
Сообщение: [BUGS]