deficiency on delete and update instead rules for views

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: deficiency on delete and update instead rules for views
Date: 2000-11-23 12:22:26
Message-ID: 11C1E6749A55D411A9670001FA687963368139@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


We lack a syntax that would enable us to write an on update/delete do instead rule
that would efficiently map an update/delete to a table that is referenced by a view.

Currently the only rule you can implement is one that uses a primary key.
This has the disadvantage of needing a self join to find the appropriate rows.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-11-23 12:38:27 Re: deficiency on delete and update instead rules for views
Previous Message Philip Warner 2000-11-23 11:49:53 Re: Please advise features in 7.1