On Rollback my sequency does not back the initial value

From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: On Rollback my sequency does not back the initial value
Date: 2006-10-05 18:50:58
Message-ID: 55c095e90610051150x128edd9andf999a8ad873b28f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ...

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message William Leite Araújo 2006-10-05 19:02:37 Postgresql quey planner
Previous Message Martin Marques 2006-10-05 18:43:39 Re: age() vs. timestamp substraction