Re: Statement-level trigger results in recursion

Поиск
Список
Период
Сортировка
От Jitendra Loyal
Тема Re: Statement-level trigger results in recursion
Дата
Msg-id CAGBkusc4rhvTL7D4zmrXK2WYGACU+xreXNfy5eDX6ecO+K1UTw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Statement-level trigger results in recursion  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
Thanks for all your efforts. I appreciate it.

Let us wait and see if someone can enlighten us, or you locate the conversation.

Thanks once again

Regards,
Jiten

On Tue 19 Feb, 2019, 3:19 AM Adrian Klaver, <adrian.klaver@aklaver.com> wrote:
On 2/18/19 9:07 AM, Jitendra Loyal wrote:
> I do understand that the statement level trigger will be executed once
> before the operation. My point is.. if one does not know the rows, what
> kind of use it can be put to. What is the use case? Like in after
> triggers, one gets the rows in transition tables, how does one do with
> vefore trigger.

Use FOR EACH ROW.

Why you cannot use a FOR EACH STATEMENT trigger is something I thought I
remember being discussed on the list before. Unfortunately I cannot find
that conversation at the moment. Someone else will need to weigh in on this.

>
> Thanks and regards,
> Jiten


--
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2
Следующее
От: Jitendra Loyal
Дата:
Сообщение: Re: BEFORE ... Statement-level trigger