Hi,
Perhaps another way to work around this is to use GENERATED BY DEFAULT as IDENTITY.
But how?
I dont want the user to define the id.
Ok i can use a helper table which holds the id
create table state_id
(
ID int not null
)
insert into state_id values (0)
and doing the follwing two commands for every state insert:
update state_id set id = ((select id from state_id) +1)
insert into state values ((select id from state_id), (select id from
state_id))
Looks quite ugly for me.
