Postgres Pro
Downloads
Home   >   mailing lists

Re: Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL? - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL?
Date
Msg-id 228a6c8f-694e-7550-67bf-ce6e6dafb2c4@postgresfriends.org
Whole thread Raw
In response to Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL?  (Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>)
Responses Re: Should we support new definition for Identity column : GENERATED BY DEFAULT ON NULL?
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: lastOverflowedXid does not handle transaction ID wraparound
Next
From: Amit Kapila
Date:
Subject: Re: Data is copied twice when specifying both child and parent table in publication