Menu

#3 Need trigger to validate log types

open
nobody
None
5
2011-03-01
2011-03-01
No

Since log_types is an array, there is no foreign key checking against l_log_type.

We need a trigger that will check all the array elements against l_log_type on insert or update.

Discussion


Log in to post a comment.