Re: postgresql not updating the sequence

From: Raymond O'Donnell <rod(at)iol(dot)ie>
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:22:55
Message-ID: 4DC1451F.1080002@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/05/2011 08:10, kosna wrote:
> 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.

Can you show us your query? Also, are you using any sort of framework or
ORM, or just sending the query directly to the server?

The more detail you give, the better people will be able to help you.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dickson S. Guedes 2011-05-04 12:28:14 Re: postgresql not updating the sequence
Previous Message Chris Curvey 2011-05-04 12:12:06 Re: postgres segfaulting on pg_restore