Re: When are trigger function results committed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: When are trigger function results committed
Дата
Msg-id 23934.1110381925@sss.pgh.pa.us
обсуждение исходный текст
Ответ на When are trigger function results committed  ("Keith Worthington" <keithw@narrowpathinc.com>)
Список pgsql-novice
"Keith Worthington" <keithw@narrowpathinc.com> writes:
> I have a table with three trigger functions on it.  After insert the first
> (defined alphabetically) trigger fires and performs its task.  Then the second
> and finally the third triggers fire.  It does not appear that the second
> trigger can see the results of the third trigger and the third cannot see the
> results of the forth trigger.  Is this the expected behavior?  If so can
> anyone suggest how I can make the functions see the previous results?

Define "see" --- what did you try to do *exactly*?  And which PG version
is this?

            regards, tom lane

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

Предыдущее
От: "Keith Worthington"
Дата:
Сообщение: When are trigger function results committed
Следующее
От: John DeSoi
Дата:
Сообщение: Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database