In postgres if i have "id SERIAL PRIMARY KEY" and

Question

In postgres if i have "id SERIAL PRIMARY KEY" and

some other VARCHAR UNIQUE NOT NULL data. why does the id keep incrementing when i try to add some non unique piece of data. would it be possible to make it so that the id would only increment when all the conditions have been met to even be able to add another row to the table?

0

24.08.2023

6 ответов

17 просмотров

kusti420 Автор вопроса

it shouldnt? idk i just didnt expect it to behave like that. so its completely normal for it to increment even when it cant add a new row?

0

8 месяцев назад

Thomas

kusti420
it shouldnt? idk i just didnt expect it to behave ...

wut it really skips ids sometimes?

0

8 месяцев назад

kusti420 Автор вопроса

Thomas
wut it really skips ids sometimes?

yeah if u have some conditions for what data each row should have and if u try to add sth where these conditions arent met it takes up that id and it could never be used again

0

8 месяцев назад

Thomas

kusti420
yeah if u have some conditions for what data each ...

Conditions as in normal table constraints?

0

8 месяцев назад

kusti420 Автор вопроса

Thomas
Conditions as in normal table constraints?

yeah

0

8 месяцев назад