Search Postgresql Archives

Re: Primary key data type: integer vs identity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Primary key data type: integer vs identity
From: Peter Devoy <peter@xxxxxxxxx>
Date: Tue, 23 Apr 2019 14:28:15 +0100
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <alpine.LNX.2.20.1904191050120.24219@salmo.appl-ecosys.com>
References: <alpine.LNX.2.20.1904191050120.24219@salmo.appl-ecosys.com>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Primary key data type: integer vs identity
  - From: Rich Shepard

References:
- Primary key data type: integer vs identity
  - From: Rich Shepard

Prev by Date: Re: Why does log_error_verbosity not apply to server logs?
Next by Date: Re: Primary key data type: integer vs identity
Previous by thread: Re: Primary key data type: integer vs identity
Next by thread: Re: Primary key data type: integer vs identity
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux