Re: Manual fixing of plpgsql_call_handler binary location

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Manual fixing of plpgsql_call_handler binary location
Дата
Msg-id 20030628130059.M60447-100000@houston.familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Manual fixing of plpgsql_call_handler binary location -- good idea?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Manual fixing of plpgsql_call_handler binary location  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Tablespaces (was Re: [GENERAL] Physical Database
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: When will table partitioning be available..