Re: Do CustomScan as not projection capable node - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Do CustomScan as not projection capable node
Date
Msg-id 8810.1555649104@sss.pgh.pa.us
Whole thread Raw
In response to Do CustomScan as not projection capable node  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Responses Re: Do CustomScan as not projection capable node
List pgsql-hackers
Andrey Lepikhov <a.lepikhov@postgrespro.ru> writes:
> Can we include the CustomScan node in the list of nodes that do not 
> support projection?

That seems like a pretty bad idea.  Maybe it's a good thing for whatever
unspecified extension you have in mind right now, but it's likely to be
a net negative for many more.  As an example, if some custom extension has
a better way to calculate some output expression than the core code does,
a restriction like this would prevent that from being implemented.

> Reason is that custom node can contain quite arbitrary logic that does 
> not guarantee projection support.

I don't buy this for a minute.  Where do you think projection is
going to happen?  There isn't any existing node type that *couldn't*
support projection if we insisted that that be done across-the-board.
I think it's mostly just a legacy thing that some don't.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Asim R P
Date:
Subject: Re: standby recovery fails (tablespace related) (tentative patch and discussion)
Next
From: Etsuro Fujita
Date:
Subject: Re: bug in update tuple routing with foreign partitions