Search Postgresql Archives

Re: problems with currval and rollback

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Refer http://www.postgresql.org/docs/8.1/static/functions-sequence.html

On 12/23/05, Assad Jarrahian <jarraa@xxxxxxxxx> 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.
>
>               try{
>                         db.setAutoCommit(false);
>                         addLM.setInt(1, lm.getOrigin());
>                            .......
>                      addLM.executeUpdate();
>                      sql = db.createStatement();
>                       ResultSet result = sql.executeQuery("SELECT
> currval('lm_id_seq');");
>                         if (result. next()){
>                                 db.commit();
>                                 db.setAutoCommit(true);
>                          else{
>                                 db.rollback(); //reverse all changes
>                                 db.setAutoCommit(true);
>                        }
>                 catch(SQLException ex){
>                         try {
>                                 db.rollback();
>                                 db.setAutoCommit(true);
>                         } catch (SQLException e) {
>                                 throw e;
>                        }
>                         throw ex;
>            }
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>


--
Regards
Pandu


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux