TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Stop Using Serial in Postgres

54 pointsby microflash9 months ago

3 comments

pauldraper9 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.
foobarkey9 months ago
No and this is all well known stuff, none of it seems like a good reason to stop using
评论 #41469277 未加载
linotype9 months ago
Identity columns in Postgres: <a href="https:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;17&#x2F;ddl-identity-columns.html" rel="nofollow">https:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;17&#x2F;ddl-identity-columns.html</a>