| My primary reason for the schema change was to keep up with the standard syntax. Initial motivation came from this article https://blog.2ndquadrant.com/postgresql-10-identity-columns/ which explains reasons / benefits for using GENERATED BY DEFAULT AS IDENTITY over serial columns. |