In response to db.subscripti...@shepherdhill.biz : > Hi, > > I have a table with BIG SERIAL field as Primary KEY. During high load, > entries in the BIG SERIAL field are jumped. One could see a row with > 1367 and expecting the next INSERT to be 1368, one would end up > getting 1369. > > Please is this normal?
Yes. Because a serial can't rolled back. 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
