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
Дата	18 мая 2018 г. 09:48:12
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
Список	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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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