Triggers on Foreign Tables

From: Robert Lefkowitz <r0ml(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Triggers on Foreign Tables
Date: 2013-04-04 23:28:50
Message-ID: 3E9DA0C3-7AE0-4040-9411-DF54F0171925@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not sure if this is a feature request or a bug report.

I'm trying to use Foreign Tables for a variety of things and it is useful to have a foreign table which appears to be read/write.

Having set one up, I can select data from it. However, I can't insert, update or delete.

No worries, thinks I. I'll just create an INSTEAD OF TRIGGER -- and handle the updates that way.

However, one can't create a TRIGGER (in PosgreSQL version 9.2) on a foreign table -- the error message is: not a table or view.

My current workaround is to create a view which is defined as CREATE VIEW viewOnForeignTable AS SELECT * FROM foreignTable

I can then create INSTEAD OF TRIGGERs on viewOnForeignTable, as well as SELECT from viewOnForeignTable -- so that becomes the canonical interface.

However, it seems like it should be just as acceptable to apply the INSTEAD OF TRIGGERs to the FOREIGN TABLE .

Should I consider this a bug (that I can't create aTRIGGER on a foreign table?) or a feature request (to allow creating TRIGGERs on foreign tables)?

Thanks,

r0ml

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2013-04-04 23:29:39 Re: Need advice to avoid ORDER BY
Previous Message David Noel 2013-04-04 23:25:18 Re: PostgreSQL: CPU utilization creeping to 100%