Re: from_collapse_limit considerations
Antonin Houska <ah@cybertec.at> writes:
I noticed that - unlike join_collapse_limit - the from_collapse_limit does not
enforce maximum length of the top-level list. Shouldn't it do?
How would it do that? You want it to fail outright if there are more than
N tables? That seems unhelpful.
Also, the order of FROM-list items seems to affect the way RTEs are grouped
into (sub)lists.
Yeah.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Import Notes
Reply to msg id not found: 18009.1411406190@linux-j735.siteReference msg id not found: 18009.1411406190@linux-j735.site
[ I think I responded earlier but don't see my mail in the archive... ]
Tom Lane <tgl@sss.pgh.pa.us> wrote:
Antonin Houska <ah@cybertec.at> writes:
I noticed that - unlike join_collapse_limit - the from_collapse_limit does not
enforce maximum length of the top-level list. Shouldn't it do?How would it do that? You want it to fail outright if there are more than
N tables? That seems unhelpful.
Sure, truncation of the FROM list would be crazy, and that's not what I tried to propose.
--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de, http://www.cybertec.at
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers