Re: views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: views
Date
Msg-id 24629.1512579852@sss.pgh.pa.us
Whole thread Raw
In response to views  (Andrzej Barszcz <abusinf@gmail.com>)
List 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 by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Postgres with pthread
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] parallel.c oblivion of worker-startup failures