| 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
| 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 ! |