| 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: | Whole Thread | Raw Message | 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 |