Re: [SQL] pqReadData() error

Поиск
Список
Период
Сортировка
От wieck@debis.com (Jan Wieck)
Тема Re: [SQL] pqReadData() error
Дата
Msg-id m11qy99-0003kGC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на pqReadData() error  (Dipankar Chakrabarti <dipanc@yahoo.com>)
Список pgsql-sql
>
> 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

--

#======================================================================#
# 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) #

В списке pgsql-sql по дате отправления:

Предыдущее
От: Dipankar Chakrabarti
Дата:
Сообщение: pqReadData() error
Следующее
От: maxsbox
Дата:
Сообщение: Re: pgsql-sql-digest V1 #422