Commit2ffc0e8

committed

Strengthen type_sanity's check on pg_type.typarray. It failed to

complain about types that didn't have typarray set. Noted whileworking on txid patch.

1 parentff1de5c commit2ffc0e8Copy full SHA for 2ffc0e8

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -62,7 +62,7 @@ FROM pg_type as p1`
`62`	`62`	`WHERE p1.typtype in ('b','e') AND p1.typname NOT LIKE E'\\_%' AND NOT EXISTS`
`63`	`63`	`(SELECT 1 FROM pg_type as p2`
`64`	`64`	`WHERE p2.typname = ('_' \|\| p1.typname)::name AND`
`65`		`- p2.typelem = p1.oid);`
	`65`	`+ p2.typelem = p1.oid and p1.typarray = p2.oid);`
`66`	`66`	`oid \| typname`
`67`	`67`	`-----+---------`
`68`	`68`	`210 \| smgr`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -57,7 +57,7 @@ FROM pg_type as p1`
`57`	`57`	`WHEREp1.typtypein ('b','e')ANDp1.typname NOTLIKE E'\\_%'AND NOT EXISTS`
`58`	`58`	`(SELECT1FROM pg_typeas p2`
`59`	`59`	`WHEREp2.typname= ('_'\|\|p1.typname)::nameAND`
`60`		`-p2.typelem=p1.oid);`
	`60`	`+p2.typelem=p1.oidandp1.typarray=p2.oid);`
`61`	`61`
`62`	`62`	`-- Make sure typarray points to a varlena array type of our own base`
`63`	`63`	`SELECTp1.oid,p1.typnameas basetype,p2.typnameas arraytype,`

Comments

(0)