From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | does this mean i have a corruption? |
Date: | 2006-06-04 16:08:34 |
Message-ID: | 44830582.2000904@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a table to which i bulk load datasets of about up to 20,000
rows at a time. It has a primary key, plus a dataset id (bioassay_id),
however i just ran this query:
bugasbase2=# SELECT bioassay_id, count(*) from mba_data_base where
bioassay_id = 5153 group by bioassay_id;
bioassay_id | count
-------------+-------
5153 | 20000
9712 | 120
bugasbase2=# SELECT bioassay_id, count(*) from mba_data_base where
bioassay_id = 9712 group by bioassay_id;
bioassay_id | count
-------------+-------
9712 | 4624
any ideas why bioassay_id 9712 appears in the first query?? does this
suggest corruption somewhere?
thanks for any help
adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | P.M | 2006-06-04 16:55:05 | Case for postgreSQL |
Previous Message | Frank Finner | 2006-06-04 11:51:13 | 8.1.4: Installation ends up in endless recheck loops |