Re: INSERT INTO BUG

Started by Tom Laneover 24 years ago2 messagesgeneral
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

mordicus <mordicus@free.fr> writes:

NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
't210_pkey' for table 't210'
ERROR: index_formtuple: data takes 136708 bytes, max is 8191

Indexes aren't toastable, so there's a limit on how large an index
entry can be. Sorry.

regards, tom lane

#2mordicus
mordicus@free.fr
In reply to: Tom Lane (#1)

Tom Lane wrote:

Indexes aren't toastable, so there's a limit on how large an index
entry can be. Sorry.

regards, tom lane

I know, but issn field is declared as char(9) ...

When i index table t1 no problem, the problem is only when i index table
t2
(the two tables are the same).

thx