Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: Automatic PK values not added to new rows
Date
Msg-id 4d12ca7-2188-f11e-9b2d-2098e2acfcf@appl-ecosys.com
Whole thread Raw
In response to Re: Automatic PK values not added to new rows  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Automatic PK values not added to new rows
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Automatic PK values not added to new rows
Next
From: Rich Shepard
Date:
Subject: Re: Automatic PK values not added to new rows