Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
Дата
Msg-id 12851.1468363332@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress  (Peter Olivier <Peter.Olivier@mediashop.be>)
Список pgsql-general
Peter Olivier <Peter.Olivier@mediashop.be> writes:
> I create a foreign table F1 on Database local which points to Remote.R1
> When updating F1 the trigger on Remote.R1 fires but gives the following warning:
> WARNING:  there is no transaction in progress

Seems odd, but I think you'll have to give a complete example for
anyone to diagnose it.  Also, what PG versions are in use exactly,
both local and remote?

            regards, tom lane


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
Следующее
От: "dandl"
Дата:
Сообщение: Re: Question about antijoin