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