Re: Sequence Incrementing by 2 insted of 1
| От | David |
|---|---|
| Тема | Re: Sequence Incrementing by 2 insted of 1 |
| Дата | |
| Msg-id | 20090428063819.GB17477@daboyz.dyndns.org обсуждение исходный текст |
| Ответ на | Re: Sequence Incrementing by 2 insted of 1 ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
| Ответы |
Re: Sequence Incrementing by 2 insted of 1
|
| Список | pgsql-general |
Looked for that can't find anything and there is no reason why someone would have added that. On Tue, Apr 28, 2009 at 08:24:46AM +0200, A. Kretschmer wrote: > In response to David : > > Our internal task database is doing something odd in that the sequence is incrementing by 2 instead of 1 and I can'tfind any reason why I have checked the > > sequence itself to see if it had somehow got set to increment by 2 but no. The table in question has a number of bothbefore and after triggers that do > > various bits of business logic as well as some rewrite rules to track field changes. Using 8.3.0. Can anyone think ofa reason why? > > Wild guess: there are an other call to nextval() in one of the triggers. > But without the code it is hard to guess... > > > Regards, Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > --
В списке pgsql-general по дате отправления: