I'm seeing this weird issue pop up on one a database.
This seems to work...
robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE title ~*
'postgresql' LIMIT 20;
count
-------
19
(1 row)
...but these two seem to be causing an error now.
robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE body ~*
'postgresql' LIMIT 20;
ERROR: missing chunk number 0 for toast value 58441
robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE
body_html ~* 'postgresql' LIMIT 20;
ERROR: missing chunk number 0 for toast value 58440
I tried reindexing the table but it''s not going away. Any pointers?
Robby
--
Robby Russell
Founder & Executive Director
PLANET ARGON, LLC
Ruby on Rails Development, Consulting & Hosting
www.planetargon.com
www.robbyonrails.com
+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4068 [fax]
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
