I checked sequence definitions via SQLStudio, "Cached values" is disabled, without information.
SEQUENCE_CACHE = 1 according to DBM. Is there anything else to check? I created the sequence like: create sequence seq_xxx start with 1 Did it assume a default cache of 20 or something? Regards, Martin On 7/4/06, Robert Klemme <[EMAIL PROTECTED]> wrote:
2006/7/4, Martin Cordova <[EMAIL PROTECTED]>: > Hello: > > I have a sequence that jumps 19 values when used the first time after > a database restart. > > Normally it works fine, until a Db restart, then jumps 19 values. This might be due to caching of sequence values. Kind regards robert
-- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
