Received: from web106.yahoomail.com (web106.yahoomail.com [205.180.60.73]) by hub.org (8.9.3/8.9.3) with SMTP id AAA16815 for ; Fri, 26 Nov 1999 00:42:30 -0500 (EST) (envelope-from dipanc@yahoo.com) Message-ID: <19991126054228.18011.rocketmail@web106.yahoomail.com> Received: from [203.197.121.6] by web106.yahoomail.com; Thu, 25 Nov 1999 21:42:28 PST Date: Thu, 25 Nov 1999 21:42:28 -0800 (PST) From: Dipankar Chakrabarti Subject: Re: pgsql-sql-digest V1 #424 To: pgsql-sql@hub.org Cc: wieck@debis.com MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Dear Jan, Thank you very much for your mail. I really require to do the change as 80% of my functions are more than 2k. It would be nice, if I get your help. Regards, Dipankar Chakrabarti Senior Manager (Projects) Mindteck (I) Ltd. >> >> 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 __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one place. Yahoo! Shopping: http://shopping.yahoo.com