Re: Index on regexes

On Thu, June 13, 2013 22:19, Alexander Korotkov wrote:

> [index_on_regexes.1.patch.gz ]

Hi,

Compile of core is OK, but contrib compilation fails:

-- [2013.06.13 23:23:14 idxregex] make contrib
trgm_gin.c: In function ‘gin_regexp_trgm_config’:
trgm_gin.c:410:2: error: unknown type name ‘GinConfig’
GinConfig *ginConfig = (GinConfig *)PG_GETARG_POINTER(0);
^
trgm_gin.c:410:26: error: ‘GinConfig’ undeclared (first use in this function)
GinConfig *ginConfig = (GinConfig *)PG_GETARG_POINTER(0);
^
trgm_gin.c:410:26: note: each undeclared identifier is reported only once for each function it appears in
trgm_gin.c:410:37: error: expected expression before ‘)’ token
GinConfig *ginConfig = (GinConfig *)PG_GETARG_POINTER(0);
^
trgm_gin.c:412:11: error: request for member ‘addInfoTypeOid’ in something not a structure or union
ginConfig->addInfoTypeOid = BYTEAOID;
^
make[1]: *** [trgm_gin.o] Error 1
make: *** [all-pg_trgm-recurse] Error 2
trgm_gin.c: In function ‘gin_regexp_trgm_config’:
trgm_gin.c:410:2: error: unknown type name ‘GinConfig’
GinConfig *ginConfig = (GinConfig *)PG_GETARG_POINTER(0);
^
trgm_gin.c:410:26: error: ‘GinConfig’ undeclared (first use in this function)
GinConfig *ginConfig = (GinConfig *)PG_GETARG_POINTER(0);
^
trgm_gin.c:410:26: note: each undeclared identifier is reported only once for each function it appears in
trgm_gin.c:410:37: error: expected expression before ‘)’ token
GinConfig *ginConfig = (GinConfig *)PG_GETARG_POINTER(0);
^
trgm_gin.c:412:11: error: request for member ‘addInfoTypeOid’ in something not a structure or union
ginConfig->addInfoTypeOid = BYTEAOID;
^
make[1]: *** [trgm_gin.o] Error 1
make: *** [install-pg_trgm-recurse] Error 2

It is also not entirely clear from your post how this index is created, I suppose the regex index is only in trgm?

create index test_gin_idx on test (s gin_regexp_trgm_ops); --> right?

thanks,

Erik Erijkers