On Sat, Jan 8, 2011 at 6:10 AM, melzaiady wrote:
>
> http://postgresql.1045698.n5.nabble.com/file/n3332998/data1.jpg
>
> this picture of screen you can new sequence of value.
>
> now how can i slove this problem and this field dont start new squences in
> any time ?
It's pretty hard to tell what'
http://postgresql.1045698.n5.nabble.com/file/n3332998/data1.jpg
this picture of screen you can new sequence of value.
now how can i slove this problem and this field dont start new squences in
any time ?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-5809-bigser
On Wed, Jan 5, 2011 at 12:38 AM, Melzaiady wrote:
> 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 a
From: Joshua Tolley
To: Jeff Davis
Cc: mahmoud elzaiady ; 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 +, mahmoud elzaiady wrote
On Mon, Jan 03, 2011 at 11:04:17AM -0800, Jeff Davis wrote:
> On Sun, 2011-01-02 at 11:40 +, 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?
On Sun, 2011-01-02 at 11:40 +, mahmoud elzaiady wrote:
> The following bug has been logged online:
>
> Bug reference: 5809
> Logged by: mahmoud elzaiady
> Email address: melzai...@yahoo.co.uk
> PostgreSQL version: 8.4
> Operating system: windows xp
> Description:bi
The following bug has been logged online:
Bug reference: 5809
Logged by: mahmoud elzaiady
Email address: melzai...@yahoo.co.uk
PostgreSQL version: 8.4
Operating system: windows xp
Description:bigserial duplicate value
Details:
I have problem today
i have table and