Manual fixing of plpgsql_call_handler binary location -- good idea?

Adam Haberlach <adam@newsnipple.com>

From: Adam Haberlach <adam@newsnipple.com>
To: pgsql-hackers@postgresql.org
Date: 2003-06-27T21:07:47Z
Lists: pgsql-hackers
	I know that we're all in end-of-release hurry, but I've got a quick
question.

	We've got some machines that had postgres installed in /usr/local/pgsql
and we are moving their data directories, wholesale, onto machines with
postgres in the standard RedHat locations.  This works just fine except
for the hardcoded-ness of the plpgsql_call_handler having been
previously set to /usr/local/pgsql/lib/plpgsql.so

	Will I destroy things if I execute
update pg_proc set probin = '/usr/lib/pgsql/plpgsql.so' where proname = 'plpgsql_call_handler';

	On the machines?  This seems to work, but I wanted to see if anyone
out there wanted to tell me about this being a really stupid idea.

-- 
Adam Haberlach         |  "When your product is stolen by thieves, you
adam@mediariffic.com   |  have a police problem.  When it is stolen by
http://mediariffic.com |  millions of honest customers, you have a
                       |  marketing problem."  - George Gilder