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

From: easteregg(at)verfriemelt(dot)org
To: "Haribabu Kommi" <kommi(dot)haribabu(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15203: trigger does not recognize schema changes when passing on data
Date: 2018-05-18 06:48:12
Message-ID: 20180518064812.2888945c@mail.verfriemelt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fabio Pardi 2018-05-18 07:45:50 Re: help please !
Previous Message Marco Palombo 2018-05-18 05:23:55 help please !