Re: CREATE SEQUENCE with RESTART option

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Cary Huang <cary(dot)huang(at)highgo(dot)ca>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: CREATE SEQUENCE with RESTART option
Date: 2021-07-28 23:49:17
Message-ID: YQHs/bldavlug8Zb@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-07-29 00:25:30 Re: Out-of-memory error reports in libpq
Previous Message Peter Smith 2021-07-28 23:08:23 Re: Replace l337sp34k in comments.