Re: identity column behavior in WHEN condition for BEFORE EACH ROW trigger

2019-10-07 Thread Peter Eisentraut
On 2019-10-03 16:08, Suraj Kharage wrote: > It is been observed that when we define the generated columns in WHEN > condition for BEFORE EACH ROW trigger then server throw an error from > CreateTrigger(). > whereas, for identity columns, server allows us to create trigger for > same and trigger ge

Re: identity column behavior in WHEN condition for BEFORE EACH ROW trigger

2019-10-06 Thread Suraj Kharage
> whereas, for identity columns, server allows us to create trigger for same > and trigger gets invoked as defined. Is this behavior expected? or we need > to restrict the identity columns in such scenario because anyone one > override the identity column value in trigger. > Also, I think it is br