Re: plpgsql and intarray extension; int[] - int[] operator does not exist ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql and intarray extension; int[] - int[] operator does not exist ?
Дата
Msg-id 15705.1542650179@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql and intarray extension; int[] - int[] operator does notexist ?  ("Day, David" <david.day@redcom.com>)
Ответы RE: plpgsql and intarray extension; int[] - int[] operator does notexist ?  ("Day, David" <david.day@redcom.com>)
Re: plpgsql and intarray extension; int[] - int[] operator does notexist ?  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Дерево обсуждения 
"Day, David" <david.day@redcom.com> writes:
> Any suggestions as to why the int[] operations are not understood in the trigger context.?

The search_path in the trigger probably doesn't include public.
You could add a "SET search_path = whatever" clause to the trigger
function definition to ensure it runs with a predictable path.

            regards, tom lane

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations
Следующее
От: "Day, David"
Дата:
Сообщение: RE: plpgsql and intarray extension; int[] - int[] operator does notexist ?