Re: pgsql-sql-digest V1 #424

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  runafter  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