The following bug has been logged online:
Bug reference: 1913
Logged by: Keith Randall
Email address: randallk(at)gmail(dot)com
PostgreSQL version: 8.1beta2
Operating system: Linux 2.4.21-15 Redhat enterprise
Description: select into a table missing a row part 2
Details:
I'm missing a row when I generate a table off a view.
select count(*) from foo;
20811
select * into temp from foo;
select count(*) from temp;
20810
I have scripts that you can run to replicate at
https://www.oas.ca/~randallk/pgbug.tar.bz2