Re: Problem with SqlState=23505 when inserting rows
| От | Michael Lewis |
|---|---|
| Тема | Re: Problem with SqlState=23505 when inserting rows |
| Дата | |
| Msg-id | CAHOFxGoaDbQ3Ah5gEz4Dkj9eyvbVBxz+cWHprNoxxMvzbBSWQQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Problem with SqlState=23505 when inserting rows ("Werner Kuhnle" <wek@kuhnle.com>) |
| Ответы |
Re-2: Problem with SqlState=23505 when inserting rows
|
| Список | pgsql-general |
On Wed, Jan 15, 2020 at 9:41 AM Werner Kuhnle <wek@kuhnle.com> wrote:
I've tried to using the newer definition:
id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
but that does not solve the problem.
Is there a way to define id columns to that when the database provides values,
it recognizes already existing values avoiding conflicts.
You'll need to run something like the below to set the next value to the max current value. You'll just have to figure out the name of the sequence that is automatically created whether you use the pseudo type serial, or the newer IDENTITY option. Both are implemented with a sequence.
--set sequence to max ID on a table
select setval( 'table_name_id_seq', ( select max(id) + 1 from table_name ) );
В списке pgsql-general по дате отправления: