Re: Primary key data type: integer vs identity

Поиск
Список
Период
Сортировка
От Michel Pelletier
Тема Re: Primary key data type: integer vs identity
Дата
Msg-id CACxu=vJetwFKSPNtB2n0JZdR2r=BaJQGtrbgz99JmTbZaXDqUA@mail.gmail.com
обсуждение исходный текст
Ответ на Primary key data type: integer vs identity  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Primary key data type: integer vs identity  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general


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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Primary key data type: integer vs identity
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Primary key data type: integer vs identity