Re: Problem with partition tables and schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with partition tables and schemas
Дата
Msg-id 6088.1265126104@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with partition tables and schemas  (Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp>)
Ответы Re: Problem with partition tables and schemas
Список 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 по дате отправления: