Steve Wampler <[EMAIL PROTECTED]> writes:
> One of the listed bug fixes is:
>    Disallow INSERT/UPDATE/DELETE on views
> Can some one give me a little insight on what this
> implies?

It means that if you try to do INSERT/UPDATE/DELETE on a view that
doesn't have a rule to translate that action to something else, the
system will complain (rather than applying the action to the hidden
table underlying the view, as it used to do with confusing results).

> In particular, I currently (pg 7.0.3) have views with
> trigger functions on insert and update that trap the
> action and recast it to a table (after doing some checks).

> Will this still work with 7.1?

Yes.  As long as you have appropriate rules, this change won't affect
you at all.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to