Changing the Postgres serial/autoincrement behavior
In short, I don't want the serial to fill the empty gaps. I want it to always default to max(id) + 1 unless I specify the id myself. How can I achieve this with minimum jank?
I've heard of generated columns, but couldn't get it all working together. I believe MySQL works like this, so I might have to switch to that.
1 Reply
bump