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 . ________________________________ Mahmoud El Zaiady Bachelor of Information Systems Faculty of Computers & Information Sciences Mansoura University ________________________________ From: Joshua Tolley <eggyk...@gmail.com> To: Jeff Davis <pg...@j-davis.com> Cc: mahmoud elzaiady <melzai...@yahoo.co.uk>; pgsql-bugs@postgresql.org 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. -- Joshua Tolley / eggyknap End Point Corporation http://www.endpoint.com
