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

From Raymond O'Donnell
Subject Re: postgresql not updating the sequence
Date
Msg-id 4DC1451F.1080002@iol.ie
Whole thread Raw
In response to postgresql not updating the sequence  (kosna <skosna@yahoo.com>)
List 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@iol.ie

pgsql-general by date:

Previous
From: Jens Wilke
Date:
Subject: undead index
Next
From: Merlin Moncure
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys