Postgres Pro
Downloads
Home   >   mailing lists

Re: PK issue: serial sequence needs updating [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: PK issue: serial sequence needs updating [RESOLVED]
Date
Msg-id alpine.LNX.2.20.2011171601120.28478@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: PK issue: serial sequence needs updating  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
On Tue, 17 Nov 2020, Adrian Klaver wrote:

> https://www.postgresql.org/docs/12/sql-altersequence.html
> ALTER SEQUENCE people_person_nbr_seq RESTART 485;

Thanks, Adrian. I missed that page.

Regards,

Rich

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PK issue: serial sequence needs updating
Next
From: "David G. Johnston"
Date:
Subject: Re: create type with %type or %rowtype