Postgres Pro
Downloads
Home   >   mailing lists

postgres_fdw regression tests order dependency - Mailing list pgsql-hackers

From Andrew Dunstan
Subject postgres_fdw regression tests order dependency
Date
Msg-id 51B4EBA6.1040800@dunslane.net
Whole thread Raw
Responses Re: postgres_fdw regression tests order dependency
List pgsql-hackers
Tree view 
It looks like the postgres_fdw's regression tests expect data back from 
the following statement in a given order, which presumably isn't guaranteed:
   UPDATE ft2 SET c2 = c2 + 600 WHERE c1 % 10 = 8 RETURNING *;

See 
<http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=frogmouth&dt=2013-06-08%2018%3A30%3A00>

Maybe we need to wrap this in a CTE and then order the results for 
consistency?

cheers

andrew

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Optimising Foreign Key checks
Next
From: Noah Misch
Date:
Subject: Valgrind Memcheck support