Postgres Pro
Downloads
Home   >   mailing lists

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

From Michel Pelletier
Subject Re: Primary key data type: integer vs identity
Date
Msg-id CACxu=vJetwFKSPNtB2n0JZdR2r=BaJQGtrbgz99JmTbZaXDqUA@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
List pgsql-general
Tree view


On Fri, Apr 19, 2019 at 10:55 AM Rich Shepard <rshepard@appl-ecosys.com> wrote:
When I created the database I set primary key data types as integer; for
example:

Column    |   Type          | Collation | Nullable |  Default
--------------+-----------------------+-----------+----------+-------------
  org_id   | integer         |           | not null |
nextval('organizations_org_id_seq'::regclass)

I probably should have used the serial type, but didn't.

If it would be advisable for me to convert from integer to identity please
point me to the appropriate work flow.


 
"The data types smallserial, serial and bigserial are not true types, but merely a notational convenience for creating unique identifier columns"

so really there's no difference, what you have is fine. 

-Michel



Reading the CREATE TABLE pages in the manual did not give me sufficient
insights to appreciate the differences or indicate how to change the
column's data type.

Regards,

Rich


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Primary key data type: integer vs identity
Next
From: Rich Shepard
Date:
Subject: Re: Primary key data type: integer vs identity