Re: [GENERAL] duplicate key violates unique on a nextval() field

2011-08-30 Thread Peter Warasin
's not related to the bigserial primary key. aah, stupid me. thank you! ok, then back to coova-chilli :) peter -- :: e n d i a n :: security with passion :: peter warasin :: http://www.endian.com :: pe...@endian.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] duplicate key violates unique on a nextval() field

2011-08-30 Thread Peter Warasin
happens only from time to time. it must be related to load. when the system is under heavy load something goes wrong and 2 concurrent transactions get the same unique id. but how?? peter -- :: e n d i a n :: security with passion :: peter warasin :: http://www.endian.com :: pe...@endian.c

[GENERAL] duplicate key violates unique on a nextval() field

2011-08-30 Thread Peter Warasin
: e n d i a n :: security with passion :: peter warasin :: http://www.endian.com :: pe...@endian.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] duplicate key violates unique on a nextval() field

2011-08-30 Thread Peter Warasin
: e n d i a n :: security with passion :: peter warasin :: http://www.endian.com :: pe...@endian.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general