strange error occurs when adding index

Поиск
Список
Период
Сортировка
От Juan Backson
Тема strange error occurs when adding index
Дата
Msg-id 27c25bc40909040242j69f7492cxad2f5b76eb071e05@mail.gmail.com
обсуждение исходный текст
Ответы Re: strange error occurs when adding index  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
Hi,
 
When I tried to add the following index, I get some strange error.  Does anyone know what these errors mean and how to fix it?
 
Here is the index query:
create index idx_product_items_digits on product_items using gist (digits gist_prefix_range_ops,product_id)
 
 
Here is the error:
NOTICE:  __pr_penalty(sa[], a1928901[]) orig->first=0 orig->last=0NOTICE:  __pr_penalty(sa[], 1206323[]) orig->first=0 orig->last=0
NOTICE:  __pr_penalty(a1206329[], 1206370[]) orig->first=0 orig->last=0NOTICE:  __pr_penalty(a1206329[], a1206328[]) orig->first=0 orig->last=0NOTICE:  __pr_penalty(a120632[8-9], 1206369[]) orig->first=56 orig->last=57
NOTICE:  __pr_penalty(a120632[8-9], a1206327[]) orig->first=56 orig->last=57NOTICE:  __pr_penalty(a120632[7-9], 1206368[]) orig->first=55 orig->last=57NOTICE:  __pr_penalty(a120632[7-9], a1206326[]) orig->first=55 orig->last=57NOTICE:  __pr_penalty(a120632[6-9], 1206367[]) orig->first=54 orig->last=57NOTICE:  __pr_penalty(a120632[6-9], a1206325[]) orig->first=54 orig->last=57NOTICE:  __pr_penalty(a120632[5-9], 1206366[]) orig->first=53 orig->last=57NOTICE:  __pr_penalty(a120632[5-9], a1206324[]) orig->first=53 orig->last=57NOTICE:  __pr_penalty(a120632[4-9], 1206365[]) orig->first=52 orig->last=57NOTICE:  __pr_penalty(a120632[4-9], a1206323[]) orig->first=52 orig->last=57NOTICE:  __pr_penalty(a120632[3-9], 1206364[]) orig->first=51 orig->last=57NOTICE:  __pr_penalty(a120632[3-9], a1206322[]) orig->first=51 orig->last=57NOTICE:  __pr_penalty(a120632[2-9], 1206363[]) orig->first=50 orig->last=57NOTICE:  __pr_penalty(a120632[2-9], a1206321[]) orig->first=50 orig->last=57NOTICE:  __pr_penalty(a120632[1-9], 1206362[]) orig->first=49 orig->last=57NOTICE:  __pr_penalty(a120632[1-9], a1206320[]) orig->first=49 orig->last=57NOTICE:  __pr_penalty(a120632[0-9], 1206361[]) orig->first=48 orig->last=57NOTICE:  __pr_penalty(a120632[0-9], a1206319[]) orig->first=48 orig->last=57NOTICE:  __pr_penalty(a12063[1-2], 1206359[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], a1206318[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], 1206358[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], a1206315[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], 1206357[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], a1206314[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], 1206356[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], a1206313[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], 1206355[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], a1206312[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], 1206354[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], a1206310[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], 1206353[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[1-2], a1206309[]) orig->first=49 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], 1206352[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206307[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], 1206351[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206306[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], 1206350[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206304[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], 1206349[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206303[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], 1206347[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206302[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1952240[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206301[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1952240[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206300[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1952240[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a12063[0-2], a1206299[]) orig->first=48 orig->last=50NOTICE:  __pr_penalty(a1206[2-3], a1952240[]) orig->first=50 orig->last=51NOTICE:  __pr_penalty(a1206[2-3], a1206298[]) orig->first=50 orig->last=51NOTICE:  __pr_penalty(a1206[2-3], a1952240[]) orig->first=50 orig->last=51NOTICE:  __pr_penalty(a1206[2-3], a1206297[]) orig->first=50 orig->last=51NOTICE:  __pr_penalty(a1206[2-3], a1952240[]) orig->first=50 orig->last=51NOTICE:  __pr_penalty(a1206[2-3], a1206296[]) orig->first=50 orig->last=51NOTICE:  __pr_penalty(a1206[2-3], a1952240[]) orig->first=50 orig->last=51NOTICE:  __pr_penalty(a1206[2-3], a1206295[]) orig->firs
 
 
Thanks for your help.
 
jb

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Need help in copying a table from one database to other
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: query speed question