On Wed, Mar 04, 2020 at 03:04:34PM +0100, Vik Fearing wrote:
> On 04/03/2020 14:05, stan wrote:
> > I am missing something about how to properly create a rule.
>
> What you are missing is that you should not ever use RULEs.
>
> > Thanks to the helpful folks on this list, I am looking a creating some
> > update able views. So, looks like I need to create a rule and a function
> > for this.
>
> Use an INSTEAD OF trigger on the view unless it's a simple view in which
> case it "just works".
OK, I certainly believe you have more knowledge than I do here Just let me
make certain what I am trying to do fits that model.
I am trying to create an "update-able view" on a view that dereferences a
number of keys to foreign tables to make the view more "human friendly". so
it is going to need to look up those keys before allowing the insert into
the base table(s).
Can you please explain the difference between triggers and rules?
I have some experience with using triggers in other situations, but the
documentation for update-able views seemed to point me to rules.
Tanks.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin