Re: Problem with partition tables and schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with partition tables and schemas
Date
Msg-id 6088.1265126104@sss.pgh.pa.us
Whole thread Raw
In response to Problem with partition tables and schemas  (Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp>)
Responses Re: Problem with partition tables and schemas  (Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp>)
List pgsql-general
Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp> writes:
> my problem is, when I insert data into the visit table it tries to
> find the session data in the live schema. I have no idea why, because
> no schema was copied or inherited from the other side.

I think you need to schema-qualify the table names used in the triggers.
As-is they'll be sensitive to whatever your search_path is.

            regards, tom lane

pgsql-general by date:

Previous
From: Josh Kupershmidt
Date:
Subject: ERROR: relation xxx is still open (Re: Use Trigger to Remove Table ... )
Next
From: Tom Lane
Date:
Subject: Re: ERROR: relation xxx is still open (Re: Use Trigger to Remove Table ... )