> 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 breaking the OVERRIDING SYSTEM VALUE clause in INSERT
statement. i.e: without this clause, can insert the modified value from
trigger in identity column. I don't find any document reference for this
behavior.
Thoughts?
--
--
Thanks & Regards,
Suraj kharage,
EnterpriseDB Corporation,
The Postgres Database Company.