Re: [SQL] index row size 2728 exceeds btree maximum, 2713

Поиск
Список
Период
Сортировка
От Ramakrishnan Muralidharan
Тема Re: [SQL] index row size 2728 exceeds btree maximum, 2713
Дата
Msg-id 02767D4600E59A4487233B23AEF5C5992A408F@blrmail1.aus.pervasive.com
обсуждение исходный текст
Ответы Re: [SQL] index row size 2728 exceeds btree maximum, 2713
Список pgsql-general
Дерево обсуждения
         Hi,
 
             The issue looks like your Index width exceeds the maximum width  of the index key limit, Please review the keys used in the index.
 
Regards,
R.Muralidharan
 
     
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Dinesh Pandey
Sent: Thursday, June 02, 2005 12:35 PM
To: pgsql-general@postgresql.org; 'PostgreSQL'
Subject: [SQL] index row size 2728 exceeds btree maximum, 2713

TABLE

-----------+-----------------------+-----------

  Column    |         Type      

-----------+-----------------------+-----------

 scan_id    | bigint               

 host_ip    | character varying(15)

 port_num | integer              

 plugin_id  | integer               

 severity   | character varying(50)

 data       | text                 

Indexes:

    "pk_scanned_port_info" PRIMARY KEY, btree (scan_id, host_ip, port_num, plugin_id, severity, data)

 

 

On inserting record I am getting this error “index row size 2728 exceeds btree maximum, 2713”

 

How to solve this problem?

 

 

 

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