Re: Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL?

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL?
Дата
Msg-id 228a6c8f-694e-7550-67bf-ce6e6dafb2c4@postgresfriends.org
обсуждение исходный текст
Ответ на Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL?  (Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>)
Ответы Re: Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL?  (David Fetter <david@fetter.org>)
Список pgsql-hackers
Дерево обсуждения 
On 11/2/21 12:19 PM, Himanshu Upadhyaya wrote:
> Hi,
> 
> Trying to insert NULL value to the Identity column defined by "GENERATED BY
> DEFAULT" is disallowed, but there can be use cases where the user would
> like to have an identity column where manual NULL insertion is required(and
> it should not error-out by Postgres).

What could possibly be the use case for this?

> Thoughts?

I don't like it.
-- 
Vik Fearing

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

Предыдущее
От: Andrey Borodin
Дата:
Сообщение: Re: lastOverflowedXid does not handle transaction ID wraparound
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Data is copied twice when specifying both child and parent table in publication