pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Dinesh Pandey <dpandey@secf.com>
To: pgsql-general@postgresql.org
To: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: index row size 2728 exceeds btree maximum, 2713
Date: Thu, 2 Jun 2005 12:34:58 +0530
Message-ID: <20050602071021.512DC5286E@svr1.postgresql.org> (raw)

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?

 

 

 

view thread (18+ messages)  latest in thread

Message-ID: <20050602071021.512DC5286E@svr1.postgresql.org>
Permalink:  ../20050602071021.512DC5286E@svr1.postgresql.org/
Also on:    postgresql.org/message-id/20050602071021.512DC5286E@svr1.postgresql.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dpandey@secf.com, pgsql-general@postgresql.org
  Subject: Re: index row size 2728 exceeds btree maximum, 2713
  In-Reply-To: <20050602071021.512DC5286E@svr1.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox