X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 55CE49DCA2D for ; Tue, 28 Feb 2006 01:54:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30985-05 for ; Tue, 28 Feb 2006 01:54:13 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 602DD9DC9E4 for ; Tue, 28 Feb 2006 01:54:12 -0400 (AST) Received: from cygnus.stpp.soft.net (cygnus.stpp.soft.net [203.129.226.210]) by svr4.postgresql.org (Postfix) with ESMTP id AECA05AF02B for ; Tue, 28 Feb 2006 05:54:10 +0000 (GMT) Received: from pratapgadh (pratapgadh.cygnus.com [192.168.0.114]) by cygnus.stpp.soft.net (8.12.8/8.12.8) with SMTP id k1S5ew0m027655 for ; Tue, 28 Feb 2006 11:11:16 +0530 Message-ID: <00b201c63c2b$0c4497c0$7200a8c0@CYGNUS.COM> From: "Suvarna" To: Subject: problem in sequence Date: Tue, 28 Feb 2006 11:21:23 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00AF_01C63C59.1B182180" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.48 required=5 tests=[AWL=-0.000, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.48 X-Spam-Level: X-Archive-Number: 200602/336 X-Sequence-Number: 20757 This is a multi-part message in MIME format. ------=_NextPart_000_00AF_01C63C59.1B182180 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable In postgresql 7.3.2 if the server shuts down abruptly then sequence does = not behave properly. Next val after rebooting server shows gsp between last number & next val ------=_NextPart_000_00AF_01C63C59.1B182180 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
In postgresql 7.3.2 if the server shuts = down=20 abruptly then sequence does not behave properly.
Next val after rebooting server shows = gsp between=20 last number & next val
------=_NextPart_000_00AF_01C63C59.1B182180--