(13 rows)

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

ERROR: new row for relation "T 1" violates check constraint "c2positive"

DETAIL: Failing row contains (10, -2, 00010_trig_update_trig_update, 1970-01-11 08:00:00+00, 1970-01-11 00:00:00, 0, 0 , foo).

CONTEXT: Remote SQL command: UPDATE "S 1"."T 1" SET c2 = $2 WHERE ctid = $1

release savepoint s2;

select c2,count(*)from ft2where c2<500group by1order by1;

savepoint s3;

update ft2set c2=-2where c2=42;-- fail on remote side

update ft2set c2=-2where c2=42and c1=10;-- fail on remote side

rollback to savepoint s3;

select c2,count(*)from ft2where c2<500group by1order by1;

release savepoint s3;