Clemens Schwaighofer <clemens_schwaighofer(at)e-gra(dot)co(dot)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