NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit46aaa5d

committed

Appears there is a problem finding the opclass when indexing a domain.

CREATE DOMAIN newint as int4;CREATE TABLE tab (col newint unique);ERROR: data type newint has no default operator class for access method"btree" You must specify an operator class for the index or define a default operator class for the data typeSpecifically, GetDefaultOpClass() finds 0 exact matches and 3 binarycompatible matches. Fetching getBaseType() of the attribute fixes theproblem for domains (see attachment).Rod Taylor

1 parent45e2544 commit46aaa5dCopy full SHA for 46aaa5d

File tree

1 file changed

-1

lines changed

src/backend/commands
- indexcmds.c

1 file changed

-1

lines changed

`‎src/backend/commands/indexcmds.c‎`

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/commands/indexcmds.c,v 1.81 2002/08/07 21:45:01 tgl Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/indexcmds.c,v 1.82 2002/08/15 02:53:35 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -482,6 +482,9 @@ GetDefaultOpClass(Oid attrType, Oid accessMethodId)`
`482`	`482`	`OidexactOid=InvalidOid;`
`483`	`483`	`OidcompatibleOid=InvalidOid;`
`484`	`484`
	`485`	`+/* It could be a domain */`
	`486`	`+attrType=getBaseType(attrType);`
	`487`	`+`
`485`	`488`	`/*`
`486`	`489`	`* We scan through all the opclasses available for the access method,`
`487`	`490`	`* looking for one that is marked default and matches the target type`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit46aaa5d

File tree

1 file changed

1 file changed

`‎src/backend/commands/indexcmds.c‎`

0 commit comments