How to enable plpgsql functions (and triggers)

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема How to enable plpgsql functions (and triggers)
Дата
Msg-id 382B3764.3AAB7382@austin.rr.com
обсуждение исходный текст
Список pgsql-general
I wanted to use PL/pgsql to write some functions for use with
triggers, and thought others might benefit from a concise description
of how to enable this without having to scour the postgresql
documentation.  This was with a default install of pgsql v6.5.2 on
RH6.0.

    CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
             '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';

    CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
             HANDLER plpgsql_call_handler
             LANCOMPILER 'PL/pgSQL';

Ref:  http://www.postgresql.org/docs/postgres/xplang.htm#XPLANG-TITLE

The trigger example at
http://www.postgresql.org/docs/postgres/xplang19094.htm does not work
without this (there's also a missing single quote after "AS").

Cheers.


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

Предыдущее
От: Marcin Inkielman
Дата:
Сообщение: Re: [GENERAL] Postgres concurrency : urgent
Следующее
От: Ed Loehr
Дата:
Сообщение: How to enable PL/pgsql for functions/triggers