Re: Reset sequence to current maximum value of rows

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Reset sequence to current maximum value of rows
Date: 2024-06-13 19:50:07
Message-ID: 828cb6d2-bc1-f370-9e49-6b5be418d683@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-06-13 19:57:19 Re: Reset sequence to current maximum value of rows
Previous Message Tom Lane 2024-06-13 19:39:30 Re: Reserving GUC prefixes from a non-preloaded DB extension is not always enforced