Re: BUG #14126: INSERT ON CONFLICT DO NOTHING auto increments serial primary key when no insert happens.

From: Casey Wireman <cwire4(at)gmail(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14126: INSERT ON CONFLICT DO NOTHING auto increments serial primary key when no insert happens.
Date: 2016-05-07 01:15:57
Message-ID: CAMDTB5h9u-++utUwd+Mj79wLuCi_BPiM8QdZDOSSFGHQwULuWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks everyone for the answers. This clears it up. Apologies for
submitting a duplicate issue on this, and I agree that it would benefit
from a bit of coverage in the docs.

On Fri, May 6, 2016 at 2:21 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:

> On Fri, May 6, 2016 at 11:20 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> > Maybe we should add a note to the docs then?
>
> I was just about to suggest that. It's getting out of hand.
>
> I'll look into it.
>
>
> --
> Peter Geoghegan
>

--
Casey

Browse pgsql-bugs by date

  From Date Subject
Next Message vincenzo.romano 2016-05-07 06:30:42 BUG #14128: PGDG package has a typo
Previous Message Paul 2016-05-06 21:39:00 Re: BUG #13846: INSERT ONCONFLICTconsumessequencersonconflicts