postgresql not updating the sequence

From: kosna <skosna(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgresql not updating the sequence
Date: 2011-05-04 07:10:25
Message-ID: 1304493025736-4369180.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-not-updating-the-sequence-tp4369180p4369180.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2011-05-04 07:25:54 Re: pervasiveness of surrogate (also called synthetic) keys
Previous Message Guillaume Lelarge 2011-05-04 06:56:29 Re: Needs Suggestion