Thread: Has the Update savepoint example outlived its usefulness?

Has the Update savepoint example outlived its usefulness?

From
"David G. Johnston"
Date:
Hey,

The example in the update documentation that does an upsert using a savepoint seems like it should just go away now that we have insert...on conflict.  Making an explicit reference (and link) to that feature in the Update documentation should be added in its place (well, under notes).

David J.

Re: Has the Update savepoint example outlived its usefulness?

From
Peter Eisentraut
Date:
On 04.06.21 02:08, David G. Johnston wrote:
> The example in the update documentation that does an upsert using a 
> savepoint seems like it should just go away now that we have insert...on 
> conflict.  Making an explicit reference (and link) to that feature in 
> the Update documentation should be added in its place (well, under notes).

Do we need to replace it by a different example then?



Re: Has the Update savepoint example outlived its usefulness?

From
"David G. Johnston"
Date:
On Thu, Jun 24, 2021 at 4:20 AM Peter Eisentraut <peter.eisentraut@enterprisedb.com> wrote:
On 04.06.21 02:08, David G. Johnston wrote:
> The example in the update documentation that does an upsert using a
> savepoint seems like it should just go away now that we have insert...on
> conflict.  Making an explicit reference (and link) to that feature in
> the Update documentation should be added in its place (well, under notes).

Do we need to replace it by a different example then?

I don't think so.  The example that replaces it already exists on the INSERT documentation page, we just need to remove this example on the UPDATE page and point the user there instead.

David J.