Re: ERROR: index row size

Поиск
Список
Период
Сортировка
Искать
От
Rodrigo Sakai
Тема
Re: ERROR: index row size
Дата
Msg-id
001801c7a661$a70994d0$6500a8c0@NOTEBOOKSAKAI
Ответ на
Список
Дерево обсуждения
ERROR: index row size "Rodrigo Sakai" <rodrigo.sakai@poli.usp.br>
Re: ERROR: index row size Jeremy Drake <pgsql@jdrake.com>
Re: ERROR: index row size "Rodrigo Sakai" <rodrigo.sakai@poli.usp.br>
Re: ERROR: index row size Tom Lane <tgl@sss.pgh.pa.us>
Re: ERROR: index row size "Rodrigo Sakai" <rodrigo.sakai@poli.usp.br>
Re: ERROR: index row size "Rodrigo Sakai" <rodrigo.sakai@poli.usp.br>
>Indeed ... *please* tell us your compiler issued a warning about that.

I did shell scripts that suppress the warnings, so it was a big mistake, I
agree! But I think my problem is not here!

> Well, you oughta allocate result before you store into it, not after,
> and I bet you meant to assign to the tvi and tvf fields, not tvi twice.
You are right again. But this happened because I copy and paste the example
with a different order. But in my code all this is ok!

>Bad as these mistakes are, they don't directly explain why a later index
>entry creation would fail.  What I'm betting is that your CREATE TYPE
>command does not correctly describe the datatype size.  Based on this
>code it should be pass-by-reference, fixed-size-8-bytes, but I'll bet
>a nickel your CREATE TYPE says something else --- probably varlena.

Humm, this can help! I will investigate! Thanks a lot!


В списке pgsql-hackers по дате отправления
От: Rodrigo Sakai
Дата:
Сообщение: Re: ERROR: index row size
От: Tom Lane
Дата:
FAQ