Postgres Pro
Downloads
Home   >   mailing lists

Re: Inserting a record into another table ... inside a - Mailing list pgsql-general

From Rich Shepard
Subject Re: Inserting a record into another table ... inside a
Date
Msg-id Pine.LNX.4.61.0505050826230.4693@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Inserting a record into another table ... inside a schema  (John DeSoi <desoi@pgedit.com>)
Responses Re: Inserting a record into another table ... inside a
List pgsql-general
Tree view 
On Thu, 5 May 2005, John DeSoi wrote:

>> 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 ?
>
> You want search_path -- see

   Pardon my ignorance, but why wouldn't it work to specify the schema with
the table; e.g., update myschema.table1?

Rich

--
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
<http://www.appl-ecosys.com>   Voice: 503-667-4517   Fax: 503-667-8863

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres, tablespaces, and quotas
Next
From: "A. Mous"
Date:
Subject: Postmaster not reporting number of connections correctly