molenzwiebel / Impostor

Automatic Discord muting for Among Us! No installs necessary, just enter the code, join the voice channel, and you're off!
https://impostor.molenzwiebel.xyz/
129 stars 14 forks source link

Use proper specific type for 'id' #9

Open aPinat opened 3 years ago

aPinat commented 3 years ago

IDENTITY is supposed to be used since its introduction in Postgres 10 anyways.. Also the bot never generates the ID itself, so let Postgres just do it always. Fixes the weird NotNullConstraintViolationException people have.

aPinat commented 3 years ago

Only works, if you don't connect back to the same session... Because the ALWAYS doesn't allow Postgres to overwrite. Alt would have been `PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, but apparently it results in the same exception. So, just leave it open for now I guess...