Postgres Pro
Downloads
Home   >   mailing lists

Re: How to sort deleted rows with trigger. Some rows before then some rows after. - Mailing list pgsql-sql

From David G. Johnston
Subject Re: How to sort deleted rows with trigger. Some rows before then some rows after.
Date
Msg-id CAKFQuwY94C9z54SKUh00Mbeo7DDS9jfr5Q1AS3P9Uzo2TtoeMQ@mail.gmail.com
Whole thread Raw
In response to Re: How to sort deleted rows with trigger. Some rows before then some rows after.  (intmail01 <intmail01@gmail.com>)
List pgsql-sql
Tree view
On Mon, Sep 20, 2021 at 8:54 AM intmail01 <intmail01@gmail.com> wrote:

How to use transaction in a trigger ? It seems there is no possibility to control transaction within function


You cannot.  You don't get to introduce a transaction boundary in the middle of a statement's execution.  Not to mention what it would mean to have transaction boundaries for deferred triggers.

David J.

pgsql-sql by date:

Previous
From: intmail01
Date:
Subject: Re: How to sort deleted rows with trigger. Some rows before then some rows after.
Next
From: Rob Sargent
Date:
Subject: Re: How to sort deleted rows with trigger. Some rows before then some rows after.