[SQL] On Rollback my sequency does not back the initial value

[Ezequias Rodrigues da Rocha]

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/