Re: Converting to identity columns with domains on PK columns

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Converting to identity columns with domains on PK columns
Дата
Msg-id b092296f-f2e4-4e62-57a7-12ff2ea00b19@aklaver.com
обсуждение исходный текст
Ответ на Re: Converting to identity columns with domains on PK columns  (PegoraroF10 <marcos@f10.com.br>)
Ответы Re: Converting to identity columns with domains on PK columns  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Converting to identity columns with domains on PK columns  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On 7/4/19 1:03 PM, PegoraroF10 wrote:
> ok, thanks for the explanation but ... I cannot add a field and move data,
> constraints, triggers, identity to it because my pk field will be
> repositioned to the last field on that table and I have lots of other codes
> which point to pk as the first field on every table.

I stay away from using the index position of field for this reason.

> 
> So, there is a way to convert that field to a identity field ?

See my second option in previous post.

Or, old school identity column:):

create sequence id_seq owned by mytable.id;

alter table mytable alter column id set default nextval('id_seq');

\d mytable
                          Table "public.mytable"
    Column    | Type | Collation | Nullable |           Default
-------------+------+-----------+----------+-----------------------------
  id          | i32  |           | not null | nextval('id_seq'::regclass)
  description | t50  |           |          |
Indexes:
     "mytable_pkey" PRIMARY KEY, btree (id)


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


-- 
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: PegoraroF10
Дата:
Сообщение: Re: Converting to identity columns with domains on PK columns
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Why does jsonb_set() remove non-mentioned keys?