Re: Automatic PK values not added to new rows

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Automatic PK values not added to new rows
Date: 2022-05-25 17:45:53
Message-ID: c8e3b0d2-dd92-3764-74c2-fb70b6b8bbc4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-05-25 17:52:19 Re: Automatic PK values not added to new rows
Previous Message Rich Shepard 2022-05-25 17:43:14 Automatic PK values not added to new rows