Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 91D259FB32A for ; Thu, 5 Oct 2006 15:51:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 68454-10 for ; Thu, 5 Oct 2006 15:51:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 73A079FA372 for ; Thu, 5 Oct 2006 15:51:00 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id 23so257359ugr for ; Thu, 05 Oct 2006 11:50:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=SEn4lw06PIfGfBF7NKlsb7wptVpA9tyG3L5QRK32Pm+8rq4PLzIOKARDOGOL/FCjnftdZ8c/Hn6+9+ijm2qom+X55litYPkYxQUP9ct4Yp+yyCrnbAvG+Py/1cE3gkwqiM8wIYzHAP+rIOY1ykuNR4xWLgOGSxWK2ir7s5RRPms= Received: by 10.66.220.17 with SMTP id s17mr2312116ugg; Thu, 05 Oct 2006 11:50:58 -0700 (PDT) Received: by 10.67.94.13 with HTTP; Thu, 5 Oct 2006 11:50:58 -0700 (PDT) Message-ID: <55c095e90610051150x128edd9andf999a8ad873b28f@mail.gmail.com> Date: Thu, 5 Oct 2006 15:50:58 -0300 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: On Rollback my sequency does not back the initial value MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_55221_25521391.1160074258278" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.681 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/65 X-Sequence-Number: 26454 ------=_Part_55221_25521391.1160074258278 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, I am implementing a function that execute a rollback then some exception is throwed. The problem is that my nextval('mysequency') does not return to the initial value when the rollback is executed. Does anybody have any experiency with it ? Regards ... --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_55221_25521391.1160074258278 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi,

I am implementing a function that execute a rollback then some e= xception is throwed.

The problem is that my nextval('mysequency') do= es not return to the initial value when the rollback is executed.

Does anybody have any experiency with it ?

Regards ...

--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-
          = ;            &n= bsp;           Atenc= iosamente (Sincerely)
            = ;            Ez= equias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que= a melhor das ditaduras
The worst of democracies is still better than th= e better of dictatorships
http://ezequiasrocha.bl= ogspot.com/ ------=_Part_55221_25521391.1160074258278--