Il giorno ven, 17/07/2009 alle 20.17 -0500, Sami M. Kallio ha scritto:
> Anyone successfully using SERIAL? I am having a problem since it seems
> DbLinq code calls the sequence twice, and when it happens, the serial
> gets incremented again. When I insert the first record to a table, the
> serial is set to 1, however the object returned by DbLinq tells me the
> serial is 2. I traced the problem to Upsert in QueryRunner.
> First:
> int rowsCount = dbCommand.Command.ExecuteNonQuery();
>
> "INSERT INTO public.session (sessionid) VALUES
> (nextval('session_sessionid_seq'))" // <- first increment
>
> Next:
> // the second reads output parameters
>
> SqlStatement "SELECT nextval('session_sessionid_seq')" // <-
> second increment?This is in fact wrong but doesn't happen here when I run the tests. Are you using the last SVN version? federico -- Federico Di Gregorio http://people.initd.org/fog Debian GNU/Linux Developer [email protected] INIT.D Developer [email protected] Degli altri, della gente senza domande, si puo' fare a meno. -- macchinavapore
signature.asc
Description: Questa รจ una parte del messaggio firmata digitalmente
