Re: postgresql not updating the sequence

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: kosna <skosna(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql not updating the sequence
Date: 2011-05-04 12:28:14
Message-ID: BANLkTi=r9X+Uid2PZcfP+ZBMjoXBW=qM9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2011/5/4 kosna <skosna(at)yahoo(dot)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(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-05-04 12:34:31 Re: pervasiveness of surrogate (also called synthetic) keys
Previous Message Raymond O'Donnell 2011-05-04 12:22:55 Re: postgresql not updating the sequence