Commit9472ae0

committed

pathman: isolation tests (not finished)

1 parent8541cbb commit9472ae0Copy full SHA for 9472ae0

File tree

+32

-1

lines changed

+32

-1

lines changed

Lines changed: 10 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -9,7 +9,7 @@ DATA_built = $(EXTENSION)--$(EXTVERSION).sql`
`9`	`9`	`PGFILEDESC = "pg_pathman - partitioning tool"`
`10`	`10`
`11`	`11`	`REGRESS = pg_pathman`
`12`		`-EXTRA_CLEAN =$(EXTENSION)--$(EXTVERSION).sql`
	`12`	`+EXTRA_CLEAN =$(EXTENSION)--$(EXTVERSION).sql ./isolation_output`
`13`	`13`
`14`	`14`	`ifdefUSE_PGXS`
`15`	`15`	`PG_CONFIG = pg_config`
`@@ -25,3 +25,12 @@ endif`
`25`	`25`	`$(EXTENSION)--$(EXTVERSION).sql: init.sql hash.sql range.sql`
`26`	`26`	`cat$^>$@`
`27`	`27`	`check: EXTRA_REGRESS_OPTS=--temp-config=$(top_srcdir)/$(subdir)/conf.add`
	`28`	`+`
	`29`	`+ISOLATIONCHECKS=insert_trigger`
	`30`	`+`
	`31`	`+isolationcheck:`
	`32`	`+$(MKDIR_P) isolation_output`
	`33`	`+$(pg_isolation_regress_check)\`
	`34`	`+ --temp-config=$(top_srcdir)/$(subdir)/conf.add\`
	`35`	`+ --outputdir=./isolation_output\`
	`36`	`+$(ISOLATIONCHECKS)`

Lines changed: 22 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,22 @@`
	`1`	`+setup`
	`2`	`+{`
	`3`	`+--SELECT'>>> SETUP <<<';`
	`4`	`+CREATEEXTENSIONpg_pathman;`
	`5`	`+CREATETABLErange_rel(idserialprimarykey);`
	`6`	`+SELECTcreate_range_partitions('range_rel','id',1,100,1);`
	`7`	`+}`
	`8`	`+`
	`9`	`+teardown`
	`10`	`+{`
	`11`	`+--SELECT'>>> TEARDOWN <<<';`
	`12`	`+--SELECTdrop_range_partitions('range_rel');`
	`13`	`+DROPTABLErange_relCASCADE;`
	`14`	`+DROPEXTENSIONpg_pathman;`
	`15`	`+}`
	`16`	`+`
	`17`	`+session"s1"`
	`18`	`+step"s1i" {INSERTINTOrange_relSELECTgenerate_series(1,150); }`
	`19`	`+step"s1d" {SELECT*FROMpg_inheritsWHEREinhparent='range_rel'::regclass::oid; }`
	`20`	`+`
	`21`	`+session"s2"`
	`22`	`+step"s2i" {INSERTINTOrange_relSELECTgenerate_series(151,300); }`

Comments

(0)