Search Postgresql Archives

Re: PK issue: serial sequence needs updating [RESOLVED]

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

Subject: Re: PK issue: serial sequence needs updating [RESOLVED]
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Tue, 17 Nov 2020 16:01:47 -0800 (PST)
In-reply-to: <aebfdd1d-c38f-b1b7-51f4-a7842d4b3ec1@aklaver.com>
References: <alpine.LNX.2.20.2011171537470.28478@salmo.appl-ecosys.com> <aebfdd1d-c38f-b1b7-51f4-a7842d4b3ec1@aklaver.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

On Tue, 17 Nov 2020, Adrian Klaver wrote:

https://www.postgresql.org/docs/12/sql-altersequence.html
ALTER SEQUENCE people_person_nbr_seq RESTART 485;


Thanks, Adrian. I missed that page.

Regards,

Rich

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

References:
- PK issue: serial sequence needs updating
  - From: Rich Shepard
- Re: PK issue: serial sequence needs updating
  - From: Adrian Klaver

Prev by Date: Re: PK issue: serial sequence needs updating
Next by Date: Re: create type with %type or %rowtype
Previous by thread: Re: PK issue: serial sequence needs updating
Next by thread: received immediate shutdown request caused cluster failover
Index(es):
- Date
- Thread

[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