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 <mw...@1080agile.com>
Cc:
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 <mw...@1080agile.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was change
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
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 <mw...@1080agile.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] all seria
c: Max Wang <mw...@1080agile.com>; Amitabh Kant <amitabhk...@gmail.com>;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] all serial type was changed to 1
On Mon, May 1, 2017 at 7:45 PM, Adrian Klaver
<adrian.kla...@aklaver.com<mailto:adrian.kla...@aklaver.com>> wrot
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 <mw...@1080agile.com>;
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 <mw...@1080agile.com>
Cc: pgsql-general@postgresql.org
S
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 <mw...@1080agile.com>
Cc: Adrian Klaver <adrian.kla...@aklaver.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL
...@aklaver.com]
Sent: Tuesday, 2 May 2017 9:31 AM
To: Max Wang <mw...@1080agile.com>; Amitabh Kant <amitabhk...@gmail.com>
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