Re: [GENERAL] all serial type was changed to 1 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [GENERAL] all serial type was changed to 1
Date
Msg-id f25d7103-617e-e0af-ca5a-c30506578a87@aklaver.com
Whole thread Raw
In response to Re: [GENERAL] all serial type was changed to 1  (Max Wang <mwang@1080agile.com>)
Responses Re: [GENERAL] all serial type was changed to 1  (Melvin Davidson <melvin6925@gmail.com>)
Re: [GENERAL] all serial type was changed to 1  (Max Wang <mwang@1080agile.com>)
List pgsql-general
On 05/01/2017 04:11 PM, Max Wang wrote:
> Hi Amitabh,
>
>
>
> Thank you for suggestion. We did not reach the limit of serial type.
> Some tables only have hundreds of rows.

It would helpful if you ran the query I showed in my previous post on
one the sequences just so we can see.

 From subsequent post of yours:

"Sorry. I mean all tables’ id column were reset to 1."

I thought I understood on this, now I am not sure. Do you mean that the
actual values in the id column in all the tables have been set to 1 or
that the serial sequence that controls the id value has been set to 1?

>
>
>
> Regards,
>
> Max
>
>



--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Max Wang
Date:
Subject: Re: [GENERAL] all serial type was changed to 1
Next
From: Max Wang
Date:
Subject: Re: [GENERAL] all serial type was changed to 1