i relying on PostgreSQL to supply a default value,
i have application at hospital and application appear error about duplicate
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 .
Mahmoud El Zaiady
Bachelor of Information Systems
Faculty of Computers & Information Sciences
From: Joshua Tolley <firstname.lastname@example.org>
To: Jeff Davis <email@example.com>
Cc: mahmoud elzaiady <firstname.lastname@example.org>; email@example.com
Sent: Tue, January 4, 2011 6:34:57 PM
Subject: Re: [BUGS] BUG #5809: bigserial duplicate value
On Mon, Jan 03, 2011 at 11:04:17AM -0800, Jeff Davis wrote:
On Sun, 2011-01-02 at 11:40 +0000, mahmoud elzaiady wrote:
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?
Alternatively, perhaps at some point you've added data to that column, rather
than relying on PostgreSQL to supply a default value.