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

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Vicky Vergara <vicky_vergara(at)hotmail(dot)com>
Cc: "pgsql-hackers\(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Instead of DROP function use UPDATE pg_proc in an upgrade extension script
Date: 2017-04-04 04:28:48
Message-ID: 8760iku7bl.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2017-04-04 04:31:06 Re: Variable substitution in psql backtick expansion
Previous Message Pavan Deolasee 2017-04-04 04:23:58 Re: Patch: Write Amplification Reduction Method (WARM)