Postgres Pro
Downloads
Home   >   mailing lists

BUG #1913: select into a table missing a row part 2 - Mailing list pgsql-bugs

From Keith Randall
Subject BUG #1913: select into a table missing a row part 2
Date
Msg-id 20050927081718.B721EF11B7@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1913: select into a table missing a row part 2  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1913
Logged by:          Keith Randall
Email address:      randallk@gmail.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

pgsql-bugs by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Can not build libpq.dll with BCC
Next
From: "Cris Gamboa"
Date:
Subject: BUG #1914: Corrupted Table