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
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 |