On Tue, 23 Apr 2019, Peter Devoy wrote:
I think you may have serial already there (indicated by sequence in the the default value).
Peter, As serial is an alias for integer (the actual data type) using integer and specifying it as the primary key works.
If you wish to change to identity columns this should be useful: https://www.2ndquadrant.com/en/blog/postgresql-10-identity-columns/
Nah, I don't see a reason to change. Identity columns obviously have a benefit for some but not for me. Thanks for the suggestion, Rich
