Postgres Pro
Downloads
Home   >   mailing lists

problems with Gist when migrating from 7.1.3 -> 7.3.x - Mailing list pgsql-general

From Hans-Jürgen Schönig
Subject problems with Gist when migrating from 7.1.3 -> 7.3.x
Date
Msg-id 3E5318F0.4070606@cybertec.at
Whole thread Raw
Responses Re: problems with Gist when migrating from 7.1.3 -> 7.3.x  (Teodor Sigaev <teodor@stack.net>)
List pgsql-general
Tree view 
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>

pgsql-general by date:

Previous
From: Tim Stump
Date:
Subject: Re: nodeRead: did not find '}' at end of plan node
Next
From: cnliou9@fastmail.fm (CN)
Date:
Subject: Re: BLOB or BYTEA field