Re: Reset sequence to current maximum value of rows

Rich Shepard <rshepard@appl-ecosys.com>

From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Date: 2024-06-13T21:13:26Z
Lists: pgsql-general
On Thu, 13 Jun 2024, Jeremy Smith wrote:

> There's no need to specify the column if it has a default value, but
> specifying it did not cause the issue that you saw.

Jeremy,

I did not know this. While the reason for the issue shall remain unknown, it
did happen and my update script restored order to the table.

Thanks,

Rich