On Wed, Jan 5, 2011 at 12:38 AM, Melzaiady <melzai...@yahoo.co.uk> wrote: > i relying on PostgreSQL to supply a default value, > i have application at hospital and application appear error about > duplicate value. > There was a primary key on this columns but i found error form my > application about duplicate value and can`t insert value then i remove the > primary key constraint to try to find problem and try again i found > bigserial put duplicate value on fields .
I'm pretty sure there isn't a bug that's making the sequence return duplicate values, because if there were, a lot more people would have complained about it by now. I think there's probably a bug in your application logic, but you haven't provided enough detail to figure out what it is. I'd suggest examining your log files for clues, and perhaps posting relevant sections of them here. It's not surprising that if you're getting duplicate key errors and you drop the index, you would then get actual duplicate keys... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
