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 по дате отправления: