INSERT INTO BUG

From: mordicus <mordicus(at)free(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: INSERT INTO BUG
Date: 2001-12-02 15:50:59
Message-ID: 9udblp$1ij7$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mordicus 2001-12-02 17:47:37 Re: INSERT INTO BUG
Previous Message Tom Lane 2001-12-02 15:06:19 Re: INSERT INTO BUG