Yikes! I already done a reindexing of the table as there where locks that were holding back some jobs that needed to finished. But in case the problem should appear again we will take a copy of the actual data file.
Anyway, the case must regarded as solved. Put shortly, reindex the table/index. By the way thanks for all the effort you put into making PostgreSQL such a marvelous database manager! // John > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-bugs- > [EMAIL PROTECTED] On Behalf Of Magnus Hagander > Sent: den 22 april 2008 13:58 > To: John Parnefjord > Cc: pgsql-bugs@postgresql.org; Tom Lane > Subject: Re: [BUGS] ERROR: failed to re-find parent key in > "sl_seqlog_idx" for deletion target > > John Parnefjord wrote: > > > Please copy out the files as requested in that email - I'm sure Tom > > > is still interested in debugging it to find the issue. After that, > > > try a REINDEX to see if it solves your problem. > > > > Ok, see the snippets below. I just cut them from the PgAdminIII > > interface. Drop me a mail if you need more info. > > Ok, misunderstandment. What's needed are the actual data files, not the > definition of the tables. That is, the files under $PGDATA that > contains the table and it's indexes. > > Can't send those on-list, they're too large, but if you can put > together a .tar.gz for someone to look at. Before you send it, we'll > want to check with Tom that he's still interested in looking at it :-) > > > > > And while you're at it, you guys should be at 8.2.7, not 8.2.4.. :- > P > > > > Yes, you're right. But as we are trying out tsearch2 for full text > > searching it might just as well be a good idea to go straight to 8.3 > > during the summer. > > Probably, yes. > > > //Magnus > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
