Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 1F0354759B7 for ; Wed, 26 Jun 2002 07:47:30 -0400 (EDT) Mailbox-Line: From subhaksekar@yahoo.com Wed Jun 26 07:47:30 2002 Received: from web13108.mail.yahoo.com (web13108.mail.yahoo.com [216.136.174.153]) by postgresql.org (Postfix) with SMTP id 6358E4758E9 for ; Wed, 26 Jun 2002 07:47:21 -0400 (EDT) Message-ID: <20020626114724.36949.qmail@web13108.mail.yahoo.com> Received: from [61.11.48.111] by web13108.mail.yahoo.com via HTTP; Wed, 26 Jun 2002 04:47:24 PDT Date: Wed, 26 Jun 2002 04:47:24 -0700 (PDT) From: Subhashini Karthikeyan Subject: sequence chages after firing update To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=3.1 required=5.0 tests=X_NOT_PRESENT,RCVD_IN_OSIRUSOFT_COM,X_OSIRU_SPAM_SRC version=2.30 X-Spam-Level: *** X-Archive-Number: 200206/348 X-Sequence-Number: 8313 hi all In postgresql 7.1.3 i am updateing a row. it is a 4th record. after updation if i am firing a select query it is coming as a last record ..what shall i do to avoid that.. any help appriciated thankz in advance regards subha __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com