Re: PK issue: serial sequence needs updating [RESOLVED]

2020-11-17 Thread Rich Shepard
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

Re: PK issue: serial sequence needs updating

2020-11-17 Thread Adrian Klaver
On 11/17/20 3:46 PM, Rich Shepard wrote: Running postgresql-12.2-x86_64-1_SBo on Slackware-14.2/x86_64. My restructed business database has populated tables, but the primary keys are not aware of the current maximum number since the table rows were added external to postgres and read in using ps