cannot open segment 1 of relation...
I have started getting cannot open segment 1 of table name errors. This
problem seems to come and go.
What causes these errors and how so I fix them?
Redhat 7.2
Postgresql 7.2.1
I am using google to find the answer but have come up with nothing. I
see a few who have asked but have seen no answers.
Please let me know if I need to provide more information,
Rick
On Tue, 15 Oct 2002 15:39:22 -0400, Rick Eicher II wrote:
I have started getting cannot open segment 1 of table name errors. This
problem seems to come and go.What causes these errors and how so I fix them?
Don't know what causes it, but our recent troubles with this error were
cleared up (at least for now! Knock, knock!) by doing:
REINDEX TABLE tablename;
VACUUM FULL tablename;
--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise