Re: How to sort deleted rows with trigger. Some rows before then some rows after.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to sort deleted rows with trigger. Some rows before then some rows after.
Дата
Msg-id CAKFQuwY94C9z54SKUh00Mbeo7DDS9jfr5Q1AS3P9Uzo2TtoeMQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to sort deleted rows with trigger. Some rows before then some rows after.  (intmail01 <intmail01@gmail.com>)
Список pgsql-sql
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: intmail01
Дата:
Сообщение: Re: How to sort deleted rows with trigger. Some rows before then some rows after.
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: How to sort deleted rows with trigger. Some rows before then some rows after.