
Hello,

Let me start by congratulating everyone involved in the Postgresql project for a job well done.  I have thoroughly researched the bug in 6.3.2 with the ODBC ORDER BY as well as the patch supplied by insight for the backend.  With the help of the debug information provided by another poster I have devised a simple (maybe stupid) fix which seems to have fixed all the problems related to destroydb and delete from crashing the backend.  The change to the patch file is simple :

Instead of using :

+ 		tupType = j->jf_cleanTupType;      /*  Added by daveh@insightdist.com  5/20/98 */

I changed the line of the patch file to say ...

+ 		if (operation != CMD_DELETE) {tupType = j->jf_cleanTupType;}       /*  Added by daveh@insightdist.com  5/20/98 modified by Francois Machabee 10/21/1998  */

and voila the backend stopped crashing and the operations are completed correctly (I checked via psql \l and also doing a vacuum to check the integrity of the db).

I hope this helps people in the community.

Franï¿½ois Machabï¿½e
Nexus Informatique & Marketing, Inc. / Nexus Information Systems & Marketing, Inc.
WWW: Http://www.nexus-is.qc.ca
Email: mailto:francois@nexus-is.qc.ca


Fri, 23 Oct 1998 07:54:30 -0400
Francois Machabee <francois@nexus-is.qc.ca>
DestroyDB Patch *** Update
> Let me start by congratulating everyone involved in the Postgresql 
> project for a job well done.  I have thoroughly researched the bug in  
> 6.3.2 with the ODBC ORDER BY as well as the patch supplied by insight  
> for the backend.  With the help of the debug information provided by  
> another poster I have devised a simple (maybe stupid) fix which seems  
> to have fixed all the problems related to destroydb and delete from  
> crashing the backend.  The change to the patch file is simple :

Could you please send a new patch file? Use "diff -c" to generate it...

David, have you had a chance to look at this? Is it still a problem?

                    - Tom

Fri, 23 Oct 1998 13:50:40 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] DestroyDB Patch *** Update