Too large of a tuple corrupts table

Поиск
Список
Период
Сортировка
От Daniel Stolk
Тема Too large of a tuple corrupts table
Дата
Msg-id 3845C4B3.8584AAD8@email.com
обсуждение исходный текст
Список pgsql-general
Hi,

I seem to have a problem here.  When I try to insert a tuple that is
larger than 8192 bytes, I get an error message saying that the tuple is
too large.  Ok, that's fine.  But the problem is that the table seems to
become corrupted.  After I do this insert statement I went to psql and
did a select on the table (which doesn't have any tuples in it).  So far
so good.  But then I inserted a tuple that wasn't too large and when I
did a select on the table, I got an error message about the backend
going down or something like that.  However, I then inserted another
tuple (that wasn't too large) into the table and it seemed to go fine
and when I looked at the file size of that table in the database's data
directory, the size went up.  So the insert seems to still work but the
select doesn't?!?!  What's going on here?

Thanks for any help, Daniel Stolk

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Date & Time
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: [GENERAL] Re: pgsql-general-digest V1 #550