Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id HAA44281 for ; Thu, 25 Nov 1999 07:46:33 -0500 (EST) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@hub.org id m11qy99-0003kGC; Thu, 25 Nov 99 13:37 MET Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: [SQL] pqReadData() error To: dipanc@yahoo.com (Dipankar Chakrabarti) Date: Thu, 25 Nov 1999 13:37:11 +0100 (MET) Cc: pgsql-sql@hub.org Reply-To: wieck@debis.com (Jan Wieck) In-Reply-To: <19991125122345.9506.rocketmail@web114.yahoomail.com> from "Dipankar Chakrabarti" at Nov 25, 99 04:23:45 am X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > Hi, > > I am creating functions from saved in text files on > PostgreSQL 6.5 on linux by > $ psql mydb2 > If the function is large ( more than say 50 lines) or Maybe the functions text portion exceeds 2K? There is an index on functions source text in version 6.5. It's totally useless, left over from the history. Now there is some problem with btree indices when the items exceed 2K, that can crash the backend. I've removed this index in the actual 7.0 tree. It's not a trivial task and requires an initdb run after the modification. If you want to give it a try, I might help you to do it. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #========================================= wieck@debis.com (Jan Wieck) #