On 08/23/2012 10:19 PM, Gauthier, Dave wrote:
Updateable views. This is great. I didn't know about these. Absolutely
delicious !
I found a great example here...
http://vibhorkumar.wordpress.com/2011/10/28/instead-of-trigger/
The problem of user updating >1 alias remains, but I have no problem bouncing them if
they attempt that. Maybe return a "-E- You cannot update multiple aliases of the same
base value" (something like that). I'd just have to detect this circumstance, raise
the message and bounce (return OLD).
Does this sound doable?
With a RULE, probably not.
With a `DO INSTEAD` view trigger - available in Pg 9.1 and above - yes.
I'd recommend using a view trigger instead of a rule if at all possible.
Rules are tricksy things and sooner or later they'll bite you.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
