Re: BUG #15203: trigger does not recognize schema changes whenpassing on data

Поиск
Список
Период
Сортировка
От easteregg@verfriemelt.org
Тема Re: BUG #15203: trigger does not recognize schema changes whenpassing on data
Дата
Msg-id 20180518064812.2888945c@mail.verfriemelt.org
обсуждение исходный текст
Ответ на Re: BUG #15203: trigger does not recognize schema changes whenpassing on data  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Ответы Re: BUG #15203: trigger does not recognize schema changes whenpassing on data  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Список pgsql-bugs
is there any chance to reload the functions manually? i have a current setup which does a lot more in the functions itself and running these in a CI Test environment triggers this issue. in production this is not a problem, because the session will get restarted before reaching this point.

but to rewrite the trigger functions only for the CI is not really feaseble.

so my two questions: 

a) why is a reconnect sufficient to solve this problem?
b) shouldnt the function become aware of the change defintion of its parameter type?
c) if no - why so, when i reconnect?
d) can i manually reload the internal functions?

with best regards,
richard

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

Предыдущее
От: Marco Palombo
Дата:
Сообщение: help please !
Следующее
От: Fabio Pardi
Дата:
Сообщение: Re: help please !