problems with Gist when migrating from 7.1.3 -> 7.3.x

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: problems with Gist when migrating from 7.1.3 -> 7.3.x
Date: 2003-02-19 05:41:04
Message-ID: 3E5318F0.4070606@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hallo ...

We have a problem with Gist fields when migrating from 7.1.3 to 7.3. Our
queries lead to different results. Actually data is lost somehow.

The problem occurs when running queries like that:

where (( key2img @ '{44756,44809}' or key2img && '{49582}' ) and not key2img
&& '{47343}' )

7.1.3 seems to return the correct result. 7.3 is much faster but returns
nothing.
Is it a bug? Is it a conceptual change? What went wrong? Did anybody
encount similour problems?

Regards,

Hans
<http://kernel.cybertec.at>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CN 2003-02-19 05:55:30 Re: BLOB or BYTEA field
Previous Message Bruce Momjian 2003-02-19 05:27:38 Another trip