From: Dipankar Chakrabarti <dipanc@yahoo.com>
To: pgsql-sql@hub.org
Cc: wieck@debis.com
Subject: Re: pgsql-sql-digest V1 #424
Date: Thu, 25 Nov 1999 21:42:28 -0800 (PST)
Message-ID: <19991126054228.18011.rocketmail@web106.yahoomail.com> (raw)
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 <myfunc.txt
>>
>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: dipanc@yahoo.com, pgsql-sql@hub.org, wieck@debis.com
Subject: Re: pgsql-sql-digest V1 #424
In-Reply-To: <19991126054228.18011.rocketmail@web106.yahoomail.com>
References: <19991126054228.18011.rocketmail@web106.yahoomail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox