Re: BUG #15203: trigger does not recognize schema changes whenpassing on data - Mailing list pgsql-bugs

From easteregg@verfriemelt.org
Subject Re: BUG #15203: trigger does not recognize schema changes whenpassing on data
Date
Msg-id 20180518064812.2888945c@mail.verfriemelt.org
Whole thread Raw
In response to Re: BUG #15203: trigger does not recognize schema changes whenpassing on data  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: BUG #15203: trigger does not recognize schema changes whenpassing on data  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List 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 by date:

Previous
From: Marco Palombo
Date:
Subject: help please !
Next
From: Fabio Pardi
Date:
Subject: Re: help please !