Re: BUG #5809: bigserial duplicate value

=C2=A0i relying on PostgreSQL to supply a default value,
i=C2=A0 have application at=C2=A0 hospital and application appear error abo=
ut duplicate=20
value.=20

There was a primary key on this columns but i found error form my applicati=
on=20
about duplicate value and can`t insert value then i remove the primary key=
=20
constraint to try=C2=A0 to find problem and try again i found bigserial=C2=
=A0 put=20
duplicate value on fields=C2=A0.
=C2=A0

________________________________

Mahmoud El Zaiady
Bachelor of Information Systems
Faculty of Computers & Information Sciences
Mansoura University
=C2=A0
=C2=A0





________________________________
From: Joshua Tolley <eggyknap@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: mahmoud elzaiady <melzaiady@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
>=20
> 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, rath=
er
than relying on PostgreSQL to supply a default value.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com



=20=20=20=20=20=20=