Stop using SERIAL in Postgres is a great article on autogenerated identities in Postgres. I have SERIAL scattered around my hobby projects so it was great to have a clear explanation of why SERIAL appears in documentation sometimes and why IDENTITY is a better choice.
Yet another migration task though...