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
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
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 psql.
For example, I'm trying to add a new
