Search Postgresql Archives

Re: all serial type was changed to 1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Mon, May 1, 2017 at 11:21 AM, Max Wang <mwang@xxxxxxxxxxxxx> wrote:

Hi All,

 

We have a PostgreSQL database. There are 26 tables and we use serial type as primary key.  We had a insert error as “duplicate key value violates unique constraint, DETAIL:  Key (id)=(1) already exists.” one weeks ago. I checked and found all tables’ id were reset to 1.

 

I checked database log and did not find any useful information.  I am not sure why this happen. The only script which connect to this database is a Python script and only do normal insert/update/delete actions.

 

Please give me some suggestions if you happen to know something about this issue. I appreciate any feedback you might have.

 

I am very new to PostgreSQL and this mail list. Please let me know if I did not something wrong.

 

Thank you.

 

Regards,

Max



By any chance, has it to do anything with the Cycle option of sequences:

https://www.postgresql.org/docs/9.5/static/sql-createsequence.html 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux