postgres_fdw regression tests order dependency

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: postgres_fdw regression tests order dependency
Date: 2013-06-09 20:55:02
Message-ID: 51B4EBA6.1040800@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2013-06-09 21:25:59 Valgrind Memcheck support
Previous Message Simon Riggs 2013-06-09 17:13:15 Re: Optimising Foreign Key checks