Re: PL/pgSQL triggers with parameters don't work

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: PL/pgSQL triggers with parameters don't work
Дата
Msg-id Pine.BSF.4.21.0107111059090.99439-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на PL/pgSQL triggers with parameters don't work  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
On Wed, 11 Jul 2001 pgsql-bugs@postgresql.org wrote:

> José María Fernández González (jmfernandez@cnb.uam.es) reports a bug
> with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> PL/pgSQL triggers with parameters don't work
>
> Long Description
>     The report is for PostgreSQL 7.1.2. When you create a trigger
> which calls a function with parameters, the system links against the
> function with the same name and no parameter, and if it doesn't exist
> it tells "function doesn't exist". Tests have been made with
> PL/pgSQL-encoded functions.

Trigger functions take their arguments in a different fashion.
They should be defined as taking no regular arguments and returning
opaque and it's something like TG_ARGS in plpgsql that the create
trigger time arguments are passed in.  I believe this is described in
the documentation.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: ecpg: INITALLY DEFERRED translated into intially deferrable
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found