Re: enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM
Дата
Msg-id m3d7b1vb97.fsf@belphigor.mcnaught.org
обсуждение исходный текст
Ответ на enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM  (Marc Wrubleski <mlwruble@sorexsoftware.com>)
Список pgsql-general
Marc Wrubleski <mlwruble@sorexsoftware.com> writes:

> I installed Postgres from the 7.0.3-2 RPM on the Redhat site, and it
> works well, and the plpgsql.so library exists, but how do I enable this
> procedural language.
>
> I know how to do it from source, but my customer demands I install from
> RPM.

All you have to do is run the 'createlang' script that comes with
Postgres (see the man page).  If your customer wants this to be done
via RPM, well, that's possible (just make an RPM with no files and
postinstall/preremove scripts that do the appropriate commands).

Once 'createlang' is tun on the 'template1' database, all DBs created
after that will have your language(s) available.

-Doug

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

Предыдущее
От: Marc Wrubleski
Дата:
Сообщение: enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM
Следующее
От: Daniel ?erud
Дата:
Сообщение: Re: Re: Tables grow in size when issuing UPDATEs! Why??