On Mon, 10 Oct 2011 12:48:51 +0300, "Vlad Khorsun" <hv...@users.sourceforge.net> wrote: >> 10.10.2011 12:26, Vlad Khorsun wrote: >> >>> If such clause is inside trigger code then it not affects security >>> checks and >>> *whole* trigger code is checked. SQL standard says something about >>> security >>> checks for conditional triggers ? >> >> I believe the rules are the same. In general, it's impossible to >> evaluate the trigger condition at the prepare time (it can refer to the
>> fields of the current record), so I strongly believe we shouldn't even >> try doing that. >> >> So IMO this feature is not going to affect the body parsing and >> permission checking. > > Exactly. > > And we still must load all active PSQL triggers despite of any > declared condition. > > Seems conditional triggers have sence only for external (non-PSQL) > triggers. If you are going to add it, I'd say: add it for everything, not just non-PSQL triggers, if only for consistency :) Mark ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel