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

Поиск
Список
Период
Сортировка
От Peter Olivier
Тема PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
Дата
Msg-id 1468316384795.75095@mediashop.be
обсуждение исходный текст
Ответы Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

Hi,

 

I have the following setup:

 

Database Local has a table L1

Database Remote has a table R1 and a table R2.

Table Remote.R1 has a trigger. This trigger updates Remote.R2

 

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

 

When the trigger does not update another table everything works fine.

 

Any suggestions?

 

 

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore out of memory
Следующее
От: Tim Dawborn
Дата:
Сообщение: Re: Upsert with a partial unique index constraint violation