index row size 2728 exceeds btree maximum, 2713 - Mailing list pgsql-general

From Dinesh Pandey
Subject index row size 2728 exceeds btree maximum, 2713
Date
Msg-id 20050602071021.512DC5286E@svr1.postgresql.org
Whole thread Raw
Responses Re: index row size 2728 exceeds btree maximum, 2713  (Richard Huxton <dev@archonet.com>)
List pgsql-general

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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Deleting orphaned records to establish Ref Integrity
Next
From: "Rodríguez Rodríguez, Pere"
Date:
Subject: writting a large store procedure