Re: postgresql not updating the sequence - Mailing list pgsql-general

From Dickson S. Guedes
Subject Re: postgresql not updating the sequence
Date
Msg-id BANLkTi=r9X+Uid2PZcfP+ZBMjoXBW=qM9A@mail.gmail.com
Whole thread Raw
In response to postgresql not updating the sequence  (kosna <skosna@yahoo.com>)
List pgsql-general
2011/5/4 kosna <skosna@yahoo.com>:
> hi everyone,
>
> i ve created a table with id and datatype of id is serial
> and i ve created a  sequence on that table
> whenever i insert the new row values the id is not being incremented and it
> is giving the exception entityalreadyexists. pls help me
> thanks and regards,
> kosna.

Could you send us the result of \d your_table ?

The column has a 'nextval' ?


--
Dickson S. Guedes
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Next
From: Misa Simic
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys