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

["Ramakrishnan Muralidharan" <ramakrishnanm@xxxxxxxxxxxxxxxxxxxxxx>]

         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@xxxxxxxxxxxxxx [mailto:pgsql-sql-owner@xxxxxxxxxxxxxx]On Behalf Of Dinesh Pandey
Sent: Thursday, June 02, 2005 12:35 PM
To: pgsql-general@xxxxxxxxxxxxxx; '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?