Postgres Pro
Downloads
Home   >   mailing lists

Re: Primary key data type: integer vs identity - Mailing list pgsql-general

From Peter Devoy
Subject Re: Primary key data type: integer vs identity
Date
Msg-id CABoFc_hHFLXyXtzEfjOxh3b4aCxF7kB+cxNaRXm6Z0o2ELbdTw@mail.gmail.com
Whole thread Raw
In response to Primary key data type: integer vs identity  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Primary key data type: integer vs identity  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
Hi Rich

I think you may have serial already there (indicated by sequence in the the default value).  If you wish to change to identity columns this should be useful: https://www.2ndquadrant.com/en/blog/postgresql-10-identity-columns/

Regards


Peter

pgsql-general by date:

Previous
From: Jeremy Finzel
Date:
Subject: Re: Why does log_error_verbosity not apply to server logs?
Next
From: Rich Shepard
Date:
Subject: Re: Primary key data type: integer vs identity