[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
From:       Nicolas Huillard <nhuillard () ghs ! fr>
Date:       2000-01-28 22:31:34
[Download RAW message or body]

A little adjustment : SOME queries work with the new binary and the old indexes. Many \
other don't, as Tom and Hiroshi figured. With a new binary and after reloding the DB, \
every seems to work correctly.

Nicolas Huillard

-----Message d'origine-----
De:	Nicolas Huillard [SMTP:nhuillard@ghs.fr]
Date:	vendredi 28 janvier 2000 22:42
À:	pgsql-general@hub.org; pgsql-sql@hub.org
Objet:	RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 

Thank to everybody, I recompiled Postgres and tested it on the same DB : the \
offending SELECT worked, without any index regeneration. Maybe the order in which the \
items where inserted in the table (using COPY, before creating the index) made it \
                working.
 ... 

************


[prev in list] [next in list] [prev in thread] [next in thread]