Horton
Menu

Re: Reset sequence to current maximum value of rows

Jeremy Smith <jeremy@musicsmith.net>

View thread
From: Jeremy Smith <jeremy@musicsmith.net>
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org
Date: 2024-06-13T20:30:32Z
Lists: pgsql-general 
> Aha! So it's likely that by listing the PK column name in the list of
> columns to be inserted was what caused the problem? No need to specify
> DEFAULT for it?
>
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.