Re: INSERT INTO BUG

Started by Tom Laneover 24 years ago2 messagesgeneral

tgl@sss.pgh.pa.us

over 24 years ago

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

Import Notes

Reply to msg id not found: 9udblp$1ij7$1@news.tht.netReference msg id not found: 9udblp$1ij7$1@news.tht.net

mordicus

mordicus@free.fr

over 24 years ago

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