triggers using the correct schema ..

Поиск
Список
Период
Сортировка
От Paul Newman
Тема triggers using the correct schema ..
Дата
Msg-id D5F7521105A39145BEA6A6F47AEFFA88290784@sbserver.tripoint.local
обсуждение исходный текст
Список pgsql-general

Hi,

We have lots of schemas .. one of which is public. They all have the same set of tables and some of these have triggers. However when a trigger is fired in a schema it works on tables in the public schema instead of the “current” schema. We can put a statement similar to set search_path = “schema_x”; in the front of each trigger … but we use a script to generate these schemas so means doing a search and replace for each creation that we do. Is there a CURRENT SCHEMA type of command such that we could do …. Set search_path = CURRENT SCHEMA ?????

 

Thanks

Paul Newman

В списке pgsql-general по дате отправления:

Предыдущее
От: "Paul Newman"
Дата:
Сообщение: guids / bytea and index use ?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: [HACKERS] Inherited constraints and search paths (was Re: