Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-12-29 23:18:07
Subject: Re: [HACKERS] correlated subquery
Previous:From: Bruce MomjianDate: 1999-12-29 22:36:39
Subject: correlated subquery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group