Re: Statement-level trigger results in recursion

From: Jitendra Loyal <jitendra(dot)loyal(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Statement-level trigger results in recursion
Date: 2019-02-18 17:07:35
Message-ID: CAGBkusdRbvuJ+D1mP92HHS_nt6gCt6imaccArZ5ivQo1dT1NsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks and regards,
Jiten

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jitendra Loyal 2019-02-18 17:11:11 Re: BEFORE ... Statement-level trigger
Previous Message Andres Freund 2019-02-18 17:01:48 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2