Re: How to tell which event was fired in Trigger function

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to tell which event was fired in Trigger function
Дата
Msg-id CAKFQuwZsOTRMD9pZYf-C9srikcB8M0GKQc46NcDGZcY7HzZbNw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to tell which event was fired in Trigger function  ("Igal @ Lucee.org" <igal@lucee.org>)
Ответы Re: How to tell which event was fired in Trigger function
Список pgsql-general
Дерево обсуждения
On Wed, Jul 11, 2018 at 10:54 AM, Igal @ Lucee.org <igal@lucee.org> wrote:
On 7/11/2018 10:38 AM, Adrian Klaver wrote:
On 07/11/2018 10:36 AM, Igal @ Lucee.org wrote:
How can I tell inside the trigger function if the event was DELETE or INSERT/UPDATE?

https://www.postgresql.org/docs/10/static/plpgsql-trigger.html

This looks like it have all of the information that I need.  For some reason search engines bring up many other pages but not that one.

​For these situations I recommend bookmarking and navigating to the Table of Contents [1] for the documentation and looking for relevant chapter titles - in this case the "V. 38 - Triggers" one is right there on the main page.

https://www.postgresql.org/docs/10/static/index.html

On a related note, maybe the pl/pgsql link from the Triggers chapter should link directly to the Triggers section under pl/pgsql instead of the top of the chapter...

David J.

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

Предыдущее
От: "Igal @ Lucee.org"
Дата:
Сообщение: Re: How to tell which event was fired in Trigger function
Следующее
От: David Gauthier
Дата:
Сообщение: timestamp (military) at time zone without the suffix