Inserting a record into another table ... inside a schema

From: "Paul Newman" <pnewman(at)tripoint(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Inserting a record into another table ... inside a schema
Date: 2005-05-05 12:32:37
Message-ID: D5F7521105A39145BEA6A6F47AEFFA88290655@sbserver.tripoint.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2005-05-05 13:11:42 Re: postgresql replication
Previous Message Andrew Sullivan 2005-05-05 12:18:38 Re: postgresql replication