Re: Reset sequence to current maximum value of rows

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Reset sequence to current maximum value of rows
Date: 2024-06-13 21:13:26
Message-ID: 1a214ab-b1b8-83a5-ea62-a1a07341fc53@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-06-13 22:01:23 Re: Reset sequence to current maximum value of rows
Previous Message Jeremy Smith 2024-06-13 20:30:32 Re: Reset sequence to current maximum value of rows