Re: Manual fixing of plpgsql_call_handler binary location

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Adam Haberlach <adam@newsnipple.com>, <pgsql-hackers@postgresql.org>
Date: 2003-06-28T05:01:18Z
Lists: pgsql-hackers
> > 	Will I destroy things if I execute
> > update pg_proc set probin = '/usr/lib/pgsql/plpgsql.so' where proname = 'plpgsql_call_handler';
>
> Nope ... that's what I'd probably do.  You could alternatively use
> CREATE OR REPLACE FUNCTION if you wanted to be pure, but I'd say that
> that creates as many opportunities to make mistakes as it removes, since
> you'd have to be careful to get all the other attributes right too.

Even better change it to '$libdir/plpgsql.so'.

Chris