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

[Ramakrishnan Muralidharan]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]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?