Converting to identity columns with domains on PK columns

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема Converting to identity columns with domains on PK columns
Дата
Msg-id 1562269287792-0.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: Converting to identity columns with domains on PK columns
Re: Converting to identity columns with domains on PK columns
Список pgsql-general
Domains on Postgres are really strange to me. Am I creating a domain which is
exactly equal to integer, right ?

create domain i32 as integer;
create domain T50 as varchar(50);

Create table MyTable(
ID I32 not null primary key,
Description T50);

Then, after inserts and updates done to that table, I want to convert that
primary key to a identity column.

alter table MyTable alter ID add generated always as identity;

ERROR: identity column type must be smallint, integer, or bigint

So, What do I need do to create this identity column ?
Why Postgres consider different I32 and integer ?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



В списке pgsql-general по дате отправления: