deficiency on delete and update instead rules for views - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject deficiency on delete and update instead rules for views
Date
Msg-id 11C1E6749A55D411A9670001FA687963368139@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List 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


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Please advise features in 7.1
Next
From: Philip Warner
Date:
Subject: Re: deficiency on delete and update instead rules for views