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