TE
TechEcho
Home
24h Top
Newest
Best
Ask
Show
Jobs
English
GitHub
Twitter
Home
Stop Using Serial in Postgres
54 points
by
microflash
9 months ago
3 comments
pauldraper
9 months ago
One advantage to using sequences (not serial, but close) is that you can drive all IDs from one sequence, helping to prevent mistakes of ID misuse.
foobarkey
9 months ago
Collapse
No and this is all well known stuff, none of it seems like a good reason to stop using
评论 #41469277 未加载
linotype
9 months ago
Identity columns in Postgres: <a href="https://www.postgresql.org/docs/17/ddl-identity-columns.html" rel="nofollow">https://www.postgresql.org/docs/17/ddl-identity-columns.html</a>