2018-01-29 18:08 GMT+01:00 Simon Riggs <si...@2ndquadrant.com>: > On 29 January 2018 at 16:23, Chapman Flack <c...@anastigmatix.net> wrote: > > On 01/29/2018 11:13 AM, Simon Riggs wrote: > >> On 29 January 2018 at 15:44, Bruce Momjian <br...@momjian.us> wrote: > >>> Uh, if we know we are going to get question on this, the patch had > >>> better have an explanation of when to use it. Pushing the problem to > >>> later doesn't seem helpful. > >> > >> What problem are you referring to? > >> > >> INSERT ON CONFLICT UPDATE does ... > >> > >> MERGE allows you to ... > > In my reading of Pavel and Bruce, the only 'problem' being suggested > > is that the patch hasn't added a bit of documentation somewhere that > > lays out the relationship between these two things, more or less as > > you just did. > > I am happy to write docs as requested. > > There are currently no docs saying when INSERT ON CONFLICT UPDATE > should be used other than the ref page for that command. There is no > mention of it in the "Data Manipulation" section of the docs. > > I've included docs for MERGE so it is mentioned in concurrency and > reference sections, so it follows the same model. > > Where would people like me to put these docs? >
Depends on size - small note can be placed in MERGE docs and link from INSERT ON CONFLICT DO. Regards Pavel > > -- > Simon Riggs http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > >
