Re: execute trigger after another one

Поиск
Список
Период
Сортировка
От Stephen Cook
Тема Re: execute trigger after another one
Дата
Msg-id 5480EC7E.6080909@gmail.com
обсуждение исходный текст
Ответ на Re: execute trigger after another one  (Carlos Carcamo <eazyduiz@gmail.com>)
Список pgsql-general
On 12/4/2014 6:11 PM, Carlos Carcamo wrote:
> Yes because my update_remote.sh file calls a php file to update a
> table in mysql, and it is updated after I perform another query to
> in_kardex, so the mysql table is one query behind postgres... Any
> thoughts?

My bet is that the query run from your shell script can't see your
changes because the original transaction is still open.

-- Stephen



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

Предыдущее
От: Carlos Carcamo
Дата:
Сообщение: Re: execute trigger after another one
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: execute trigger after another one