Re: Manual fixing of plpgsql_call_handler binary location -- good idea?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Haberlach <adam(at)newsnipple(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Manual fixing of plpgsql_call_handler binary location -- good idea?
Date: 2003-06-28 00:21:12
Message-ID: 14377.1056759672@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Adam Haberlach <adam(at)newsnipple(dot)com> writes:
> 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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-06-28 03:18:18 Re: Missing array support
Previous Message Tom Lane 2003-06-28 00:18:35 Re: Possible mistake in new array syntax