|
Hi, We have lots of schemas .. one of which is public. They
all have the same set of tables and some of these have triggers. However when a
trigger is fired in a schema it works on tables in the public schema instead of
the “current” schema. We can put a statement similar to set
search_path = “schema_x”; in the front of each trigger … but
we use a script to generate these schemas so means doing a search and replace
for each creation that we do. Is there a CURRENT SCHEMA type of command such
that we could do …. Set search_path = CURRENT SCHEMA ????? Thanks Paul Newman |
