duplicate key value violates unique constraint - Mailing list pgsql-general

From Ashkar Dev
Subject duplicate key value violates unique constraint
Date
Msg-id CAHaowgV2rKK3L30DcjbEy8-L+Pz5qyv8inpsr=y_=qxuXULzLw@mail.gmail.com
Whole thread Raw
Responses Re: duplicate key value violates unique constraint  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: duplicate key value violates unique constraint  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Hi all,

how to fix a problem, suppose there is a table with id and username

if I set the id to bigint so the limit is 9223372036854775807 
if I insert for example 3 rows
id    username
--    --------------
1     abc
2     def
3     ghi

if I delete all rows and insert one another it is like

id    username
--    --------------
4     jkl


So it doesn't start again from non-available id 1, so what is needed to do to make the new inserts go into non-available id numbers?

pgsql-general by date:

Previous
From: Justin
Date:
Subject: Re: Rules versus triggers
Next
From: Adrian Klaver
Date:
Subject: Re: duplicate key value violates unique constraint