Re: Instead of DROP function use UPDATE pg_proc in an upgrade extension script

Thanks,

you answered so fast that I know I am stepping into dangerous grounds.

But I would like to know more about your experience.

Any links that you can give me to read about the code and/or issues regarding the ip4r experience?

Vicky

________________________________
De: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Enviado: lunes, 3 de abril de 2017 11:28 p. m.
Para: Vicky Vergara
Cc: pgsql-hackers(at)postgresql(dot)org
Asunto: Re: [HACKERS] Instead of DROP function use UPDATE pg_proc in an upgrade extension script

>>>>> "Vicky" == Vicky Vergara <vicky_vergara(at)hotmail(dot)com> writes:

Vicky> UPDATE pg_proc SET [...]

Vicky> So, I want to know how "safe" can you consider the second
Vicky> method, and what kind of other objects do I need to test besides
Vicky> views.

Speaking from personal experience (I did this in the upgrade script for
ip4r, in a much simpler case than yours, and broke it badly), it's not
at all safe.

--
Andrew (irc:RhodiumToad)