Re: Automatic PK values not added to new rows

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Automatic PK values not added to new rows
Date: 2022-05-25 18:17:16
Message-ID: 4d12ca7-2188-f11e-9b2d-2098e2acfcf@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 25 May 2022, David G. Johnston wrote:

> The value the sequence provides next is wholly independent of everything
> except the state of the sequence. It doesn’t care how many rows any table,
> even its owner, has. The very existence of the delete command should make
> this self-evident.

David J.,

I didn't know that.

Thanks,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2022-05-25 18:18:17 Re: Automatic PK values not added to new rows
Previous Message Adrian Klaver 2022-05-25 18:16:56 Re: Automatic PK values not added to new rows