Skip site navigation (1) Skip section navigation (2)

Re: BUG #5809: bigserial duplicate value

From: Melzaiady <melzaiady(at)yahoo(dot)co(dot)uk>
To: Joshua Tolley <eggyknap(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5809: bigserial duplicate value
Date: 2011-01-05 05:38:12
Message-ID: 977678.66417.qm@web24605.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugs
 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 <eggyknap(at)gmail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: mahmoud elzaiady <melzaiady(at)yahoo(dot)co(dot)uk>; pgsql-bugs(at)postgresql(dot)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



      

In response to

Responses

pgsql-bugs by date

Next:From: Christopher HeadDate: 2011-01-05 06:26:46
Subject: Re: BUG #5559: Full SSL verification fails when hostaddr provided
Previous:From: Robert HaasDate: 2011-01-05 03:39:01
Subject: Re: Full Text index is not using during OR operation for multiple table join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group