i tried running postgres and did a reindex.. and i got this..
................... NOTICE: relation 16596 was reindexed NOTICE: relation 16598 was reindexed NOTICE: relation 16384 was reindexed NOTICE: relation 16386 was reindexed NOTICE: relation 1262 was reindexed ERROR: Cannot create unique index. Table contains non-unique values backend> is there other ways of doing fixing this? TIA On Thursday 17 July 2003 04:58, you wrote: > jerome <[EMAIL PROTECTED]> writes: > > i was running postgres in foreground while doing a vaccum.. the vaccum > > didnt finish its job because of a power failure... > > i tried to reconnect to the db and i got this error when i issue a \d > > (hoping to see the tables..) > > ERROR: Cache lookup failed for relation 5741599 > > is there a way to retrieve my data..?? > > You might find that reindexing the system indexes will get you out of > trouble. See the REINDEX man page for the detailed procedure to follow; > it's a bit messy... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
