Re: Reset sequence to current maximum value of rows

Rich Shepard <rshepard@appl-ecosys.com>

From: Rich Shepard <rshepard@appl-ecosys.com>
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2024-06-13T19:50:07Z
Lists: pgsql-general
On Thu, 13 Jun 2024, Adrian Klaver wrote:

> You sure you did not actually do an UPDATE without a WHERE?

Adrian,

Yep. There was no row to update as I was adding a new company.

Regards,

Rich