Re: Automatic PK values not added to new rows - Mailing list pgsql-general

On 5/25/22 10:43 AM, Rich Shepard wrote:
> The People table has 965 rows; the table structure is:

> 
> person_nbr 683 is not in any row to be inserted.
> 
> I was under the impression that the person_nbr for the new rows would start
> with 966 but that's apparently not happening.
> 
> What have I missed?

Do:

  select * from people_person_nbr_seq;

and report back the results.

> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com