On Fri, Nov 25, 2011 at 11:17 PM, Simon Riggs <[email protected]> wrote:
> On Thu, Nov 24, 2011 at 11:12 PM, Maksym Boguk <[email protected]> > wrote: > > > postgres=# SELECT * from test where sections && '{2000}'; > > id | sections > > ----+---------- > > (0 rows) > > > > Ooops. > > Can you see if this is just intarray or if there are other failing cases? > > It would be good to get more info on this before I start investigating. > Thanks > I know GIST on intarray[] do not have that problem. Very likely the problem is limited to intarray[] GIN indexes only (but I going to test some other not-well known GIN indexes tomorrow). Broken FTS indexes on Hot Standby should be known years before. And I never heard such reports.
