X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BFD3352867; Thu, 2 Jun 2005 04:10:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89961-03; Thu, 2 Jun 2005 07:10:22 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 512DC5286E; Thu, 2 Jun 2005 04:10:21 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001005212.msg; Thu, 02 Jun 2005 00:10:00 -0700 Reply-To: From: "Dinesh Pandey" To: , "'PostgreSQL'" Subject: index row size 2728 exceeds btree maximum, 2713 Date: Thu, 2 Jun 2005 12:34:58 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000F_01C5676F.837179D0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVnQWMS5ZegD05mSvW9iHeSQj1olw== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Thu, 02 Jun 2005 00:10:00 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDAV-Processed: mail.secf.com, Thu, 02 Jun 2005 00:10:01 -0700 Message-Id: <20050602071021.512DC5286E@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.431 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_90_100, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/57 X-Sequence-Number: 78765 This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C5676F.837179D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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? ------=_NextPart_000_000F_01C5676F.837179D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

TABLE =

-----------+-----------------------+-----------=

  Column   =  |         = Type      

-----------+-----------------------+-----------=

 scan_id    | = bigint           &= nbsp;   

 host_ip    | character = varying(15)

 port_num | = integer           =    

 plugin_id  | integer  =             &= nbsp;

 severity   | character varying(50) =

 data       | = text           &nb= sp;     

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?

 

 

 

------=_NextPart_000_000F_01C5676F.837179D0--