|
Hi, We run with multiple identical schemas in our db.
Each schema actually represents a clients db. What we’d like to do is
have a common schema where trigger functions and the like are held whilst each
trigger defined against the tables is in there own particular schema. This would
mean that there is one function per trigger type to maintain. However at the moment we are placing the trigger
functions within each schema along with trigger itself. The reason is that we don’t
know of a function or a variable that says “Give me the schema of the
trigger that is calling this function”. We are therefore having to write
the function into every schema and then use set search_path =br1; as the first
line. This is a real headache to us since we are intending on putting 200 –
300 schemas in one db. My question is … is there such a function or
variable ? …. Or is there a better for us to achieve this ? Regards Paul Newman |
