Re: [HACKERS] Index corruption

From: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>
To: Jan Wieck <wieck(at)debis(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Index corruption
Date: 1999-12-29 23:10:14
Message-ID: 386A94D6.95E129C7@albourne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I made the patch below against 6.5.2 (you aren't the first
> who had trouble with it). Hopefully it will apply on 6.5.3
> too, haven't checked. It removes the prosrc index. Due to
> the catalog changes you need to dump (BEFORE), reinstall,
> initdb and reload.

Great! Thanks a lot, I'll rebuild it all and get it back up. A real life-saver -- I was
getting quite a bit of flak and Oracle was coming up in conversations ;-(. Now I can at
least show them that Postgres response to problems beats anything other db's can offer ;-)

> Should we eventually put it somewhere on the FTP server and
> have a pointer in the FAQ?

Yep, I think so. It is not obvious that this should be a problem (I certainly didn't
expect an index on the procedure source) and it causes severe problems.

Thanks a lot, Jan!

Adriaan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-12-29 23:18:07 Re: [HACKERS] correlated subquery
Previous Message Bruce Momjian 1999-12-29 22:36:39 correlated subquery