Hi all,
I'm playing with PGSQL 7.2b3.
I have a table with 1M row, when i do
insert into t2 select * from t1;
No err, but if i try to create indexs on t2 then i have
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
t1 and t2 have the same shema :
isds=# \d t1
Table "t1"
Column | Type | Modifiers
--------+--------------+-----------
issn | character(9) | not null
ind | character(2) |
a | text |
b | text |
c | text |
pkey is on issn field.
Any idea ?
Linux Suze 7.1 / Kernel 2.4.16 / PG 7.2b3 / GCC 2.95.2