Re: duplicate key violates unique constraint

Ron Johnson wrote:

> # select * from projects;
> project_id | username | project_name
> - ------------+----------+--------------
> 1 | foo |
> 2 | bar |
> (2 rows)
>
> dupe_filenames=# insert into projects (project_name, username )
> dupe_filenames-# values ('foo', 'bar');
> ERROR: duplicate key violates unique constraint "projects_pkey"

And you didn't insert records with those numbers by hand (not using the
sequence)? It seems your sequence is a bit behind, which only happens if
you don't always use it to generate your ids.

I suggest you check your sequence values and update it to the highest
value in use if it's too low. You should only need to do that once.

--
Alban Hertroys
alban(at)magproductions(dot)nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede

// Integrate Your World //