| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | cannot set view triggers to replica |
| Date: | 2015-05-30 02:47:04 |
| Message-ID: | 556924A8.5040508@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
It appears to be an omission that ALTER TABLE ... ENABLE TRIGGER and
similar commands don't allow acting on views, even though we now have
triggers on views.
Similarly, the ALTER TABLE ... ENABLE RULE commands only allow acting on
tables, even though rules can also exist on views and materialized views.
(Why don't we allow rules on foreign tables? Is that intentional?)
Attached is a sample patch. It appears we don't have any regression
tests for this.
| Attachment | Content-Type | Size |
|---|---|---|
| alter-table-enable-trigger-view.patch | text/x-diff | 967 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2015-05-30 02:49:47 | session_replication_role origin vs local |
| Previous Message | Andres Freund | 2015-05-30 02:41:25 | Re: [Proposal] More Vacuum Statistics |