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
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 |