Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Posted by Andrew Piskorski on
Hm, in PostgreSQL, you can "create or replace" functions, but if you use it on a function used in a trigger the trigger will break? Ouch. Or what bad thing will happen to the trigger exactly?

Is that true for any functions called by a Postgres trigger in any way, or just for the function that defines the body of the trigger?

Posted by Tilmann Singer on
Michael, I would appreciate if you could post the script you have so far, e.g. to file-storage: