BUG #1913: select into a table missing a row part 2

From: "Keith Randall" <randallk(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1913: select into a table missing a row part 2
Date: 2005-09-27 08:17:18
Message-ID: 20050927081718.B721EF11B7@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Cris Gamboa 2005-09-27 08:54:27 BUG #1914: Corrupted Table
Previous Message Keith Randall 2005-09-27 08:13:37 BUG #1912: select into a table missing a row