aboutsummaryrefslogtreecommitdiff
path: root/contrib/postgres_fdw/sql/postgres_fdw.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2013-03-12 10:47:04 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2013-03-12 10:47:04 -0400
commit0247d43dd9c4ba3d2e121f98e3d5adcf769ab1e3 (patch)
tree9b5f9194fb4c3914a96c21b23e1e5f86d4340047 /contrib/postgres_fdw/sql/postgres_fdw.sql
parentcc3f281ffb0a5d9b187e7a7b7de4a045809ff683 (diff)
downloadpostgresql-0247d43dd9c4ba3d2e121f98e3d5adcf769ab1e3.tar.gz
postgresql-0247d43dd9c4ba3d2e121f98e3d5adcf769ab1e3.zip
Avoid row-processing-order dependency in postgres_fdw regression test.
A test intended to provoke an error on the remote side was coded in such a way that multiple rows should be updated, so the output would vary depending on which one was processed first. Per buildfarm.
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
-rw-r--r--contrib/postgres_fdw/sql/postgres_fdw.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/postgres_fdw/sql/postgres_fdw.sql b/contrib/postgres_fdw/sql/postgres_fdw.sql
index 007109c7c76..6df829024d9 100644
--- a/contrib/postgres_fdw/sql/postgres_fdw.sql
+++ b/contrib/postgres_fdw/sql/postgres_fdw.sql
@@ -337,7 +337,7 @@ select c2, count(*) from ft2 where c2 < 500 group by 1 order by 1;
release savepoint s2;
select c2, count(*) from ft2 where c2 < 500 group by 1 order by 1;
savepoint s3;
-update ft2 set c2 = -2 where c2 = 42; -- fail on remote side
+update ft2 set c2 = -2 where c2 = 42 and c1 = 10; -- fail on remote side
rollback to savepoint s3;
select c2, count(*) from ft2 where c2 < 500 group by 1 order by 1;
release savepoint s3;