Re: BUG #5809: bigserial duplicate value - Mailing list pgsql-bugs

From Joshua Tolley
Subject Re: BUG #5809: bigserial duplicate value
Date
Msg-id 4d234c4c.086fec0a.3a5b.ffff892f@mx.google.com
Whole thread Raw
In response to Re: BUG #5809: bigserial duplicate value  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: BUG #5809: bigserial duplicate value
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Jean-Baptiste Veslin"
Date:
Subject: BUG #5812: ecpg problem with array of varchar when using dimension name with length > 12
Next
From: Gouse
Date:
Subject: to_timestamp returns the incorrect result for the DST fall over time.