Postgres Pro
Downloads
Home   >   mailing lists

Re: Reset sequence to current maximum value of rows - Mailing list pgsql-general

From Rich Shepard
Subject Re: Reset sequence to current maximum value of rows
Date
Msg-id 1a214ab-b1b8-83a5-ea62-a1a07341fc53@appl-ecosys.com
Whole thread Raw
In response to Re: Reset sequence to current maximum value of rows  (Jeremy Smith <jeremy@musicsmith.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jeremy Smith
Date:
Subject: Re: Reset sequence to current maximum value of rows
Next
From: Adrian Klaver
Date:
Subject: Re: Reset sequence to current maximum value of rows