Stop using SERIAL in Postgres
October 8, 2024
#database #postgresql #reading-list
🔗 Stop using SERIAL in Postgres
naiyerasif.com
Internally, Postgres generates a sequence for both
serialand identity columns, using the convention<table_name>_<column_name>_seq. But the way it manages these sequences is where things get interesting. We'll uncover these differences as we explore the issues withserialand how identity columns solve them.
continue reading on naiyerasif.com
⚠️ This post links to an external website. ⚠️
If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.