| From: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> |
|---|---|
| To: | Thom Brown <thom(at)linux(dot)com> |
| Cc: | pgsql-advocacy <pgsql-advocacy(at)postgresql(dot)org> |
| Subject: | Re: Help with 9.5 feature wiki page |
| Date: | 2015-05-21 03:07:37 |
| Message-ID: | CAEYLb_W-kyigZcBJTpSuiQLAPGkEFB-9WLQxHAYDL6c9_K5ujg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
On Wed, May 20, 2015 at 7:52 PM, Peter Geoghegan
<peter(dot)geoghegan86(at)gmail(dot)com> wrote:
> Due to some MediaWiki weirdness, I cannot login to edit it.
BTW, I wanted to edit the description of UPSERT. It's not true that
the use of a CTE can be considered a workaround. That pattern can
result in a spurious duplicate violation error with concurrent
upserters, and so I'd definitely discourage it. The only workarounds
that are robust involve subtransactions, like the plpgsql example in
the docs, and there is no declarative way to do that. You need to
catch a duplicate violation and retry to get a robust insert-or-update
outcome.
--
Regards,
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2015-05-21 03:40:14 | Re: Help with 9.5 feature wiki page |
| Previous Message | Peter Geoghegan | 2015-05-21 02:52:47 | Re: Help with 9.5 feature wiki page |