Re: Index on regexes

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: Index on regexes
Дата
Msg-id CAPpHfdukOiq72MgkyG-wH=8=kSvdbTfjcxRW2hQYj8-KXGtUqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index on regexes  ("Erik Rijkers" <er@xs4all.nl>)
Список pgsql-hackers
On Fri, Jun 14, 2013 at 1:30 AM, Erik Rijkers <er@xs4all.nl> wrote:
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

Likely I wasn't explicit enough. You need to apply this patch first:
 
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?

Oh, it was missed. Right.

------
With best regards,
Alexander Korotkov.
 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Erik Rijkers"
Дата:
Сообщение: Re: Index on regexes
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: MD5 aggregate