![[ DNS Administrator ]](/fx/dnsadmin-logo.png){kind=logo}
Opened 2 years ago
#81 new enhancement
Convert SERIAL to IDENTITY
| Reported by: | Kris Deugau | Owned by: | |
|---|---|---|---|
| Priority: | trivial | Milestone: | |
| Version: | Keywords: | ||
| Cc: |
Description
Apparently the Postgres SERIAL "type" is a bit of a hack, and is deprecated (although likely not going to be removed entirely for quite a long time).
See https://www.2ndquadrant.com/en/blog/postgresql-10-identity-columns/ for discussion and notes on its more SQL-standard replacement and converting to said replacement.
This ticket is a reminder to look into this conversion Someday(TM) when Postgres versions <10 are very thoroughly not in use any more.
Note:
See TracTickets
for help on using tickets.
