Re: CREATE SEQUENCE with RESTART option - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: CREATE SEQUENCE with RESTART option
Date
Msg-id YQHs/bldavlug8Zb@paquier.xyz
Whole thread Raw
In response to Re: CREATE SEQUENCE with RESTART option  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Jul 28, 2021 at 01:16:19PM -0400, Tom Lane wrote:
> I do not see any RESTART option in SQL:2021 11.72 <sequence generator
> definition>.  Since we don't document it either, there's really no
> expectation that anyone would use it.

Okay, good point.  I was not aware of that.

> I don't particularly think that we should document it, so I'm with Michael
> that we don't need to do anything.  This is hardly the only undocumented
> corner case in PG.

More regression tests for CREATE SEQUENCE may be interesting, but
that's not an issue either with the ones for ALTER SEQUENCE.  Let's
drop the patch and move on.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Replace l337sp34k in comments.
Next
From: Tom Lane
Date:
Subject: Re: Out-of-memory error reports in libpq