The following bug has been logged on the website: Bug reference: 7569 Logged by: Melese Tesfaye Email address: mtesf...@gmail.com PostgreSQL version: 9.2.1 Operating system: Ubuntu 12.04.1 LTS + Debian 6 (both x86_64 Description:
I had a problem with missing rows in a resultset when using WHERE .. IN after upgrading to 9.2.0. I was about to file a bug report when I found out that verion 9.2.1 was just released to address the index visibility issue. I then upgraded to 9.2.1 and followed the instructions for vacuuming and rebuilding indices (http://wiki.postgresql.org/wiki/20120924updaterelease#Steps_for_Users_of_PostgreSQL_9.2). I still missed rows in the resultset. I ended up downgrading to 9.1.5 and it works just fine without missing rows. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs