Re: Primary key data type: integer vs identity

From: Peter Devoy <peter(at)3xe(dot)co(dot)uk>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Primary key data type: integer vs identity
Date: 2019-04-23 13:28:15
Message-ID: CABoFc_hHFLXyXtzEfjOxh3b4aCxF7kB+cxNaRXm6Z0o2ELbdTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-04-23 14:17:29 Re: Primary key data type: integer vs identity
Previous Message Jeremy Finzel 2019-04-23 13:20:18 Re: Why does log_error_verbosity not apply to server logs?