|
Hi, I have a public schema with all my tables in it. I also have a schema for each company that uses our
system .. so 300 companies = 300 schemas. One of the tables has a trigger that
is trying to insert/update another table that is inside the same schema. So far
so good. However when I update the base table in schema “MySchema”
the trigger tries to insert/update a record in the public schema and not the “Current”
schema (ie the schema of the original table). Is there a system variable for “Current
Schema” ? …. If not what is the best way to achieve this ? Thanks Paul Newman |
