CODEWITHSUNDEEP
postgresql
Guillaume Alouege
Guillaume Alouege

Reputation: 790

ALTER FOREIGN TABLE and DISABLE TRIGGER not working

I use Postgresql 9.4 to synchronize two database, I use the extension postgres_fdw everything work great except, i have one table where i need to disable foreign key check, i use this statement :

ALTER TABLE foo DISABLE TRIGGER ALL;

It's work great on my local database but on my remote database the following statement do nothing : 

ALTER FOREIGN TABLE foo1 DISABLE TRIGGER ALL;

However in the documentation the feature is present, someone know if they are a limitation or a bug on this version of pgsql.

https://www.postgresql.org/docs/9.4/static/sql-alterforeigntable.html

Upvotes: 0

Views: 699

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246728

The second statement will disable all triggers defined on the foreign table on the local database.

To disable triggers in the remote database, you must login there and run ALTER DATABASE there.

Upvotes: 1

Related Questions