Problem in creating an INDEX

From: Daryl Sayers <daryl(at)ci(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem in creating an INDEX
Date: 2002-07-28 01:28:25
Message-ID: 200207280128.g6S1SPAA002522@mippet.ci.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I have a table that I used to have a working index. It seemed to fail
so I removed the index and tried to recreate it. I am now receiving errors
when building the index:

stocks=# select count(*) from history ;
count
---------
3882589
(1 row)

stocks=# CREATE INDEX ihisidda on history (hisid, hiday) ;
ERROR: ltsReadBlock: failed to read block 7960 of temporary file

I dont believe it is a disk problem as I moved the database onto a different
disk and I still get errors. Any ideas on what could be the problem.

--
Daryl Sayers
Corinthian Engineering Ph: (02) 9906 7866
Suite 19, 401 Pacific Hwy Fax: (02) 9906 1556
Artarmon, NSW, 2064 email: daryl(at)ci(dot)com(dot)au
Australia www: http://www.cordoors.com.au

Browse pgsql-admin by date

  From Date Subject
Next Message Denis Chavez 2002-07-28 04:04:53 Kerberos authentication with libpgtcl
Previous Message Tom Lane 2002-07-27 15:34:11 Re: Multiple Postmasters on Beowulf cluster