Optional REFERENCES Feature in CREATE TRIGGER Command

Поиск
Список
Период
Сортировка
От hyip@site.uottawa.ca
Тема Optional REFERENCES Feature in CREATE TRIGGER Command
Дата
Msg-id 1413.127.0.0.1.1102452995.squirrel@127.0.0.1
обсуждение исходный текст
Ответы Re: Optional REFERENCES Feature in CREATE TRIGGER Command  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Optional REFERENCES Feature in CREATE TRIGGER Command  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Hi,

The attached patch adds the optional REFERENCES syntax in CREATE TRIGGER
statement to make an automatic alias for OLD/NEW record during trigger
setup.  The implementation of this new feature makes CREATE TRIGGER
command more compatible to SQL standard, and allows the future
implementation of executing SQL commands in trigger action.

After the implementation, the extended syntax of statement is as follows.

CREATE TRIGGER name BEFORE|AFTER
    INSERT|DELETE|UPDATE [OR...] ON tablename
    [REFERENCING OLD|NEW [AS] identifier]
    [FOR [EACH] ROW|STATEMENT]
    EXECUTE PROCEDURE funcname (arguments)

The patch will also update two columns, condition_reference_old_table and
condition_reference_new_table with alias names of the OLD/NEW record in
the Triggers table of the information schema.

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_get_viewdef returns one paren too much
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Optional REFERENCES Feature in CREATE TRIGGER Command