Re: Manual fixing of plpgsql_call_handler binary location

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adam Haberlach <adam(at)newsnipple(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Manual fixing of plpgsql_call_handler binary location
Date: 2003-06-28 05:01:18
Message-ID: 20030628130059.M60447-100000@houston.familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-06-28 05:02:13 Re: When will table partitioning be available..
Previous Message Christopher Kings-Lynne 2003-06-28 04:59:20 Re: Tablespaces (was Re: [GENERAL] Physical Database