On Sun, 2011-01-02 at 11:40 +0000, mahmoud elzaiady wrote: > The following bug has been logged online: > > Bug reference: 5809 > Logged by: mahmoud elzaiady > Email address: melzai...@yahoo.co.uk > PostgreSQL version: 8.4 > Operating system: windows xp > Description: bigserial duplicate value > Details: > > I have problem today > i have table and colum type bigserial > and insert data automatic number > but i found the value duplicate > i ask ,bigserial must not duplicate the value ? > how solve this problem
This is probably due to the sequence being reset somehow. Have you dumped/reloaded recently? Did you manually back up or copy the table? What is the exact error message that you see? If it tells you the duplicated value, is it very old, perhaps 1 (indicating a reset of the sequence)? Note that, by "reset", I do not mean "overflow". I mean that the sequence might have been recreated somehow. Try to provide more detail in your bug report. See: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems Regards, Jeff Davis -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
