strange error occurs when adding index

From: Juan Backson <juanbackson(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: strange error occurs when adding index
Date: 2009-09-04 09:42:31
Message-ID: 27c25bc40909040242j69f7492cxad2f5b76eb071e05@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2009-09-04 11:07:02 Re: query speed question
Previous Message A. Kretschmer 2009-09-04 08:35:24 Re: Need help in copying a table from one database to other