Re: Problem with partition tables and schemas

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