Re: problems with currval and rollback

Without seeing the SQL statements you executed in the session it is
difficult to see your problem.

Getting a current sequence after a rollback is no problem (in 8.0
anyway).  Please note though, the sequence itself is NOT rolled back.
This is correct behaviour.  Currval will return the last sequence
retrieved for the session (using nextval),  even if other sessions have
accessed the sequence in the intervening time.

Eddy


Assad Jarrahian wrote:

>Hi all,
>   So I started to make some changes with my code here and there
>(nothing to do with the relevant lines) and suddenly currval and
>rollback don't work.
>
>
>
>
<snip content="code"/>

>What happens is that the it inserts a db, but cannot get a value back
>using currval  (ERROR: ERROR: currval of sequence "lm_id_seq" is not
>yet defined in this session 55000  ) , yet the db gets the addlm
>inserted.
>
>
>Shouldn't it rollback?
>Furthermore, why would currval suddenly stop working?
>
>Much thanks for your feedback in advance.
>
>-assad
>
>