Re: views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: views
Дата
Msg-id 24629.1512579852@sss.pgh.pa.us
обсуждение исходный текст
Ответ на views  (Andrzej Barszcz <abusinf@gmail.com>)
Список pgsql-hackers
Andrzej Barszcz <abusinf@gmail.com> writes:
> I would be happy when checkRuleResultList in rewriteDefine.c lost so strict
> conditions for returning clause. Are there any reasons to have such
> restriction for views ?

Uh, so that the results of a query that invokes the rule are well-defined?

If you think that for your application, it's okay for the RETURNING rule
to not bother providing useful data for some columns, you could just have
it return nulls for those.  But I don't think it's appropriate for the
system itself to make a value judgement like that.  If the columns don't
match up, it could very well be user error, and we should report that.

            regards, tom lane


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

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Re: Postgres with pthread
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] parallel.c oblivion of worker-startup failures