Re: Very Urgent : Sequences Problem

On Wed, Nov 19, 2008 at 10:54 AM, Kranti™ K K Parisa
<kranti.parisa@gmail.com> wrote:
> Hi,
>
> I have defined sequence on a table something like this
>
>
> CREATE SEQUENCE items_unqid_seq
>   INCREMENT 1
>   MINVALUE 0
>   MAXVALUE 9223372036854775807
>   START 7659
>   CACHE 1;
>
> this is on a table called items. where i have currently the max(unq_id) as
> 7659.
>
> and in the stored procedure when i am inserting values into the items table
> for the unq_id column i am using the sequence as follows:
>
> nextval('items_unqid_seq'::text)
>
>
> it seems to be working some times. and the sequences are not getting updated
> sometime. which is casuing primary key exceptions.
>
> please advise as soon as possible.
>
> is there any trivial problem with sequences in postgresql??

no (at least none that I know of).

maybe if you posted the source of your procedure?  I bet your error is
coming form some other source.

merlin