Postgres Pro
Downloads
Home   >   mailing lists

Re: Instead of DROP function use UPDATE pg_proc in an upgrade extension script - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Instead of DROP function use UPDATE pg_proc in an upgrade extension script
Date
Msg-id 8760iku7bl.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Instead of DROP function use UPDATE pg_proc in an upgrade extensionscript  (Vicky Vergara <vicky_vergara@hotmail.com>)
Responses Re: Instead of DROP function use UPDATE pg_proc in anupgrade extension script
List pgsql-hackers
Tree view 
>>>>> "Vicky" == Vicky Vergara <vicky_vergara@hotmail.com> writes:
Vicky> UPDATE pg_proc SET [...]
Vicky> So, I want to know how "safe" can you consider the secondVicky> method, and what kind of other objects do I need
totest besidesVicky> 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)

pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: Patch: Write Amplification Reduction Method (WARM)
Next
From: Pavel Stehule
Date:
Subject: Re: Variable substitution in psql backtick expansion