Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.

2015-05-11 Thread Peter Geoghegan
On Mon, May 11, 2015 at 1:49 AM, Thom Brown wrote: > I haven't had time for a proper read of this patch, but I did > immediately notice this: > > HINT: For example, ON CONFLICT ON CONFLICT (). > > This should perhaps either be: > > HINT: For example, ON CONFLICT (). > > or > > HINT: For example

Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.

2015-05-11 Thread Thom Brown
On 8 May 2015 at 04:43, Andres Freund wrote: > Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE. > > The newly added ON CONFLICT clause allows to specify an alternative to > raising a unique or exclusion constraint violation error when inserting. > ON CONFLICT refers to constraints that ca

Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.

2015-05-07 Thread Michael Paquier
On Fri, May 8, 2015 at 1:09 PM, Andres Freund wrote: > On May 7, 2015 9:07:55 PM PDT, Michael Paquier > wrote: >>On Fri, May 8, 2015 at 12:43 PM, Andres Freund >>wrote: >>> Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE. >> >>magpie is complaining: >>http://buildfarm.postgresql.org/cg

Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.

2015-05-07 Thread Andres Freund
On May 7, 2015 9:07:55 PM PDT, Michael Paquier wrote: >On Fri, May 8, 2015 at 12:43 PM, Andres Freund >wrote: >> Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE. > >magpie is complaining: >http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=magpie&dt=2015-05-08%2003%3A45%3A15 >And I

Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.

2015-05-07 Thread Michael Paquier
On Fri, May 8, 2015 at 12:43 PM, Andres Freund wrote: > Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE. magpie is complaining: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=magpie&dt=2015-05-08%2003%3A45%3A15 And I can reproduce the failure as well on my OSX laptop at least. --

[COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.

2015-05-07 Thread Andres Freund
Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE. The newly added ON CONFLICT clause allows to specify an alternative to raising a unique or exclusion constraint violation error when inserting. ON CONFLICT refers to constraints that can either be specified using a inference clause (by spec