/log/

/results/

/output_iso/

/tmp_check/

/tmp_check_iso/

DATA = tcn--1.0.sql

PGFILEDESC = "tcn - trigger function notifying listeners"

ISOLATION = tcn

PG_CONFIG = pg_config

PGXS :=$(shell$(PG_CONFIG) --pgxs)

Parsed test spec with 1 sessions

starting permutation: listen insert insert2 update delete

step listen: LISTEN mychannel;

step insert: INSERT INTO mytable VALUES(1, 'one');

s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='1'" from s1

step insert2: INSERT INTO mytable VALUES(2, 'two');

s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='2'" from s1

step update: UPDATE mytable SET value = 'foo' WHERE key = 2;

s1: NOTIFY "mychannel" with payload ""mytable",U,"key"='2'" from s1

step delete: DELETE FROM mytable;

s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='1'" from s1

s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='2'" from s1

{

CREATEEXTENSIONtcn;

CREATETABLEmytable (keyintPRIMARYKEY,valuetext);

FOREACHROWEXECUTEFUNCTIONtriggered_change_notification(mychannel);

}

{

DROPTABLEmytable;

}

steplisten{LISTENmychannel; }

stepinsert{INSERTINTOmytableVALUES(1,'one'); }

stepinsert2{INSERTINTOmytableVALUES(2,'two'); }

stepupdate{UPDATEmytableSETvalue='foo'WHEREkey=2; }

stepdelete{DELETEFROMmytable; }