diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2013-03-10 15:07:38 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2013-03-10 15:07:38 -0400 |
commit | f7951eef89be78c50ea2241f593d76dfefe176c9 (patch) | |
tree | a9c4b457939696e8365b8b780cbaaa0ce2993454 /contrib/postgres_fdw/sql/postgres_fdw.sql | |
parent | 21734d2fb896e0ecdddd3251caa72a3576e2d415 (diff) | |
download | postgresql-f7951eef89be78c50ea2241f593d76dfefe176c9.tar.gz postgresql-f7951eef89be78c50ea2241f593d76dfefe176c9.zip |
Band-aid for regression test expected-results problem with timestamptz.
We probably need to tell the remote server to use specific timezone and
datestyle settings, and maybe other things. But for now let's just hack
the postgres_fdw regression test to not provoke failures when run in
non-EST5EDT environments. Per buildfarm.
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
-rw-r--r-- | contrib/postgres_fdw/sql/postgres_fdw.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/postgres_fdw/sql/postgres_fdw.sql b/contrib/postgres_fdw/sql/postgres_fdw.sql index 007109c7c76..2e9e17f5f93 100644 --- a/contrib/postgres_fdw/sql/postgres_fdw.sql +++ b/contrib/postgres_fdw/sql/postgres_fdw.sql @@ -316,7 +316,7 @@ ALTER TABLE "S 1"."T 1" ADD CONSTRAINT c2positive CHECK (c2 >= 0); INSERT INTO ft1(c1, c2) VALUES(11, 12); -- duplicate key INSERT INTO ft1(c1, c2) VALUES(1111, -2); -- c2positive -UPDATE ft1 SET c2 = -c2 WHERE c1 = 1; -- c2positive +UPDATE ft1 SET c2 = -c2, c4 = null WHERE c1 = 1; -- c2positive -- Test savepoint/rollback behavior select c2, count(*) from ft2 where c2 < 500 group by 1 order by 1; @@ -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, c4 = null where c2 = 42; -- 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; |