View Triggers

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: View Triggers
Date: 2007-06-26 16:48:49
Message-ID: 262689.11242.qm@web31808.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems that insertion triggers on views will/may be added in version 8.3.
http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php

However, Tom mentioned that adding update and deletion triggers may be a bad idea:
http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php
...
However, I'm not sure that the idea scales to cover updates and
deletes; with no concept of physical tuple identity (ctid) for the view
rows, it's not clear that you can write triggers that will reliably do
the right things.
...

I am curious about the dangers could occur if UPDATE triggers were implemented on a view? I
assume that these dangers are most apparent with views that are based upon joined tables rather
than views on a single table.

Do these dangers also apply to update DO INSTEAD rules?

Could there exist any view design guidelines that if followed would allow for the safe utilization
of update triggers?

Regards,
Richard Broersma Jr.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-26 17:30:41 Re: a JOIN on same table, but 'slided over'
Previous Message Joshua D. Drake 2007-06-26 16:18:08 Re: Rule vs Trigger