Commit50edd63

committed

- test for indexes on a domain

- don't fail type-sanity checks if a domain existsRod Taylor

1 parent5243f9a commit50edd63Copy full SHA for 50edd63

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -111,11 +111,11 @@ create table defaulttest`
`111`	`111`	`( col1 ddef1`
`112`	`112`	`, col2 ddef2`
`113`	`113`	`, col3 ddef3`
`114`		`- , col4 ddef4`
	`114`	`+ , col4 ddef4PRIMARY KEY`
`115`	`115`	`, col5 ddef1NOT NULL DEFAULTNULL`
`116`	`116`	`, col6 ddef2 DEFAULT'88'`
`117`	`117`	`, col7 ddef4 DEFAULT8000`
`118`		`-, col8 ddef5`
	`118`	`+, col8 ddef5`
`119`	`119`	`);`
`120`	`120`	`insert into defaulttest defaultvalues;`
`121`	`121`	`insert into defaulttest defaultvalues;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,7 +19,7 @@`
`19`	`19`	`SELECTp1.oid,p1.typname`
`20`	`20`	`FROM pg_typeas p1`
`21`	`21`	`WHERE (p1.typlen<=0ANDp1.typlen!=-1)OR`
`22`		`-(p1.typtype!='b'ANDp1.typtype!='c'ANDp1.typtype!='p')OR`
	`22`	`+p1.typtypenotin('b','c','d','p')OR`
`23`	`23`	`NOTp1.typisdefinedOR`
`24`	`24`	`(p1.typalign!='c'ANDp1.typalign!='s'AND`
`25`	`25`	`p1.typalign!='i'ANDp1.typalign!='d')OR`
`@@ -55,7 +55,7 @@ WHERE (p1.typtype = 'c' AND p1.typrelid = 0) OR`
`55`	`55`
`56`	`56`	`SELECTp1.oid,p1.typname`
`57`	`57`	`FROM pg_typeas p1`
`58`		`-WHEREp1.typtype='b'ANDp1.typname NOTLIKE'\\_%'AND NOT EXISTS`
	`58`	`+WHEREp1.typtypein ('b','d')ANDp1.typname NOTLIKE'\\_%'AND NOT EXISTS`
`59`	`59`	`(SELECT1FROM pg_typeas p2`
`60`	`60`	`WHEREp2.typname= ('_'\|\|p1.typname)::nameAND`
`61`	`61`	`p2.typelem=p1.oid);`

Comments

(0)