Suppose we have UPDATE ... FOR EACH ROW trigger for the table. If we add new column by ALTER TABLE with some default value than the trigger fires as many times as many rows in the table. Adding new column without default value doesn't work. The case with statement level trigger doesn't work.
No comments:
Post a Comment