Project

General

Profile

« Previous | Next » 

Revision 2914

sql.py: function_exists(): Fixed bug where trigger functions needed to be excluded, since they cannot be called directly

View differences:

lib/sql.py
1065 1065
    conds = [('routine_name', function.name)]
1066 1066
    schema = function.schema
1067 1067
    if schema != None: conds.append(('routine_schema', schema))
1068
    # Exclude trigger functions, since they cannot be called directly
1069
    conds.append(('data_type', sql_gen.CompareCond('trigger', '!=')))
1068 1070
    
1069 1071
    return list(values(select(db, info_table, ['routine_name'], conds,
1070 1072
        order_by='routine_schema', limit=1, log_level=4))) != []

Also available in: Unified diff