Re: Queries using rules show no rows modified?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Queries using rules show no rows modified?
Дата
Msg-id 28342.1021043034@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Queries using rules show no rows modified?  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> The problem seems to be that recent changes broke updatable views for a
> few users. So have these basic options:

> 1. revert the changes until we have a consensus on doing the right thing
>    (seems best to me)

Reverting is not an option, unless you want to also revert 7.2's change
of execution order of ON INSERT rules; which I would resist as the new
behavior is clearly better.  But given that, both 7.2 and 7.2.1 have
command-tag behavior that is making users unhappy ... in different ways.

I think we should first concentrate on defining what we think the right
behavior should be in the long term.  Only after we know that can we
devise a plan for getting there.  I believe all the concrete suggestions
that have been made so far could be implemented straight away in 7.2.2
(if there is a 7.2.2) ... but we might settle on something that
represents a bigger change with more backwards-compatibility problems.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Queries using rules show no rows modified?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: the parsing of parameters