From: Merlin Moncure <mmoncure@gmail.com>
To: Kranti™ K K Parisa <kranti.parisa@gmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Very Urgent : Sequences Problem
Date: Wed, 19 Nov 2008 11:40:52 -0500
Message-ID: <b42b73150811190840s1b92bcc7tc45be2fe6863bfe2@mail.gmail.com> (raw)
In-Reply-To: <4478b4ac0811190754n42d9539v4bd42350fac24d1@mail.gmail.com>
References: <4478b4ac0811190754n42d9539v4bd42350fac24d1@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, kranti.parisa@gmail.com, pgsql-admin@postgresql.org
Subject: Re: [PERFORM] Very Urgent : Sequences Problem
In-Reply-To: <b42b73150811190840s1b92bcc7tc45be2fe6863bfe2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox