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
signature.asc
Description: Digital signature