"Prasad Duggineni" <[EMAIL PROTECTED]> writes: > It is throwing=20 > the following ERROR "error index "clusters_pkey" is not a btree" > I have to reindex the tables every time whenever i reboot.
Could we have a look at the contents of the first page of the index file when this is happening? Plain old "od -x" will do for making the dump. See contrib/oid2name if you need help figuring out which file is the troublesome index. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq