Hi Adrian,
Thank you. The strange things is we only use Python do insert/update/delete
and do not run other SQL command.
Regards,
Max
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, 2 May 2017 9:55 AM
To: Max Wang ; pgsql-general
increment_by | 1
max_value | 9223372036854775807
min_value | 1
cache_value | 1
log_cnt | 29
is_cycled | f
is_called | t
Regards,
Max
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Tuesday, 2 May 2017 9:49 AM
To: Adrian Klaver
Cc: Max Wang ; Amitabh Kant ;
pgsql
n.kla...@aklaver.com]
Sent: Tuesday, 2 May 2017 9:31 AM
To: Max Wang ; Amitabh Kant
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On 05/01/2017 04:11 PM, Max Wang wrote:
> Hi Amitabh,
>
>
>
> Thank you for suggestion. We did not reach the limit of
Hi Adrian,
I checked and found
is_cycled | f
Regards,
Max
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, 2 May 2017 9:16 AM
To: Max Wang ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On 05/01/2017
Sorry. I mean all tables’ id column were reset to 1.
Thanks.
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Tuesday, 2 May 2017 9:14 AM
To: Max Wang
Cc: Adrian Klaver ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On Mon, May 1, 2017 at 7
Hi Amitabh,
Thank you for suggestion. We did not reach the limit of serial type. Some
tables only have hundreds of rows.
Regards,
Max
From: Amitabh Kant [mailto:amitabhk...@gmail.com]
Sent: Monday, 1 May 2017 7:58 PM
To: Max Wang
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] all
Hi Adrian,
Only sequences (id) reset to 1.
Regards,
Max
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, 1 May 2017 11:30 PM
To: Max Wang ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On 04/30/2017 10:51
Hi David,
Thanks for suggestion. We use PostgreSQL 9.5. And we did not import or bulk
loaded data to these tables.
Regards,
Max
-Original Message-
From: David Rowley [mailto:david.row...@2ndquadrant.com]
Sent: Monday, 1 May 2017 11:05 PM
To: Max Wang
Cc: pgsql-general@postgresql.org
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 datab
