Re: [GENERAL] Inserting a record into another table ... inside a schema

2005-05-05 Thread John DeSoi
On May 5, 2005, at 8:32 AM, Paul Newman wrote: 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 sch

[GENERAL] Inserting a record into another table ... inside a schema

2005-05-05 Thread Paul Newman
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 u