Re: Errors when update a view with conditional-INSTEAD rules
| От | Tom Lane |
|---|---|
| Тема | Re: Errors when update a view with conditional-INSTEAD rules |
| Дата | |
| Msg-id | 6916.1578158024@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: Errors when update a view with conditional-INSTEAD rules (Dean Rasheed <dean.a.rasheed@gmail.com>) |
| Ответы |
Re: Errors when update a view with conditional-INSTEAD rules
|
| Список | pgsql-hackers |
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> That included a change to rewriteTargetListIU() to prevent it from
> adding dummy targetlist entries for unassigned-to attributes for
> auto-updatable views, in case they are no longer simple references to
> the underlying relation. Instead, that is left to expand_targetlist(),
> as for a normal table. However, in this case (an UPDATE on a view with
> a conditional rule), the target relation of the original query isn't
> rewritten (we leave it to the executor to report the error), and so
> expand_targetlist() ends up adding a new targetlist entry that
> references the target relation, which is still the original view.
So why did we leave it to the executor to throw an error? I have
a feeling it was either because the rewriter didn't have (easy?)
access to the info, or it seemed like it'd be duplicating code.
regards, tom lane
В списке pgsql-hackers по дате отправления: