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