Skip site navigation (1) Skip section navigation (2)

Re: ERROR: duplicate key violates unique constraint "client_alerts_PK"

From: "Laurent Yaish" <laurenty(at)gmail(dot)com>
To: "Robert Starr" <rob(at)surrenderdorothy(dot)com(dot)au>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: ERROR: duplicate key violates unique constraint "client_alerts_PK"
Date: 2007-09-13 05:48:23
Message-ID: c7e3acb10709122248s3ff73dd7u4772883afe467e57@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hi Rob,

In your insert, do not explicitly specify a value for the primary key,
instead use NEXTVAL('client_alerts_seq') which will return the next
valid value and increment the sequence.

i.e:
 insert into clients_alerts (id, client_id, alert_message,
alert_complete, date, staff_id)
values(NEXTVAL('client_alerts_seq'),'39','This is some alert
text','0','2007-05-04 12:42:05','14');


Laurent

On 9/12/07, Robert Starr <rob(at)surrenderdorothy(dot)com(dot)au> wrote:
> Hi all,
>
> I am having an issue, where I create a new table, setup the constraints
> for Auto Increment and Primary Key etc, then manually add a bunch of
> data using pgadmin similar to the following:
> insert into clients_alerts (id, client_id, alert_message,
> alert_complete, date, staff_id) values('1','39','This is some alert
> text','0','2007-05-04 12:42:05','14');
>
> That works fine, but after say, 30 of those, I have an ID of '30' (of
> course ;) )  but if I look at the sequence it says that the Current
> Value is only at 1.
>
> This then creates an issue when I want to add data via RealBasic, as it
> bails until I've tried 30+ times.   I can of course go in and manually
> change the Current Value to 30 but I have an install base of over 30
> servers and each has their own levels of data so each number would be
> different.
>
> The question is then: Is there a way to have the Current Value update
> when I initially add that data with the insert into statements?
>
> Any help greatly appreciated...
>
> Rob
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

In response to

Responses

pgadmin-support by date

Next:From: Laurent YaishDate: 2007-09-13 05:51:37
Subject: Re: restoring a backup and maintaining dependencies?
Previous:From: Robert StarrDate: 2007-09-13 04:56:06
Subject: restoring a backup and maintaining dependencies?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group