On Fri, Nov 6, 2015 at 4:54 AM, Ashutosh Bapat <ashutosh.ba...@enterprisedb.com> wrote: > PFA patch to get data sorted from the foreign server (postgres_fdw) > according to the pathkeys useful for merge join.
An idle thought. There are going to be a lot of cases where different software systems actually disagree about collation rules. I wonder if it would be valuable to have a node that just checks that each row is in fact greater than the previous row and throws an error if not. That can be optional or a parameter of the FDW but it's probably cheap enough to have enabled by default. It would save a lot of difficult to heartache since the behaviour if the inputs aren't correctly sorted will be strangely incorrect join results. Often the results may just be missing or duplicated rows and that can be easy to miss and lead to corrupted databases or security problems. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
