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 по дате отправления: