Re: Behavior of identity columns

2022-08-04 Thread Francisco Olarte
On Thu, 4 Aug 2022 at 10:52, sivapostg...@yahoo.com wrote: > I see 'identity' column values increment even when some error(s) occurs while > inserting data. Is that a known bug or known behavior? Known behaviour, explained thousand of times over the years. Identity is not a way to generate

Re: Behavior of identity columns

2022-08-04 Thread sivapostg...@yahoo.com
Hello, I see 'identity' column values increment even when some error(s) occurs while inserting data.  Is that a known bug or known behavior? Create script of table: CREATE TABLE public.users(    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1