Re: Supplements and suggestions and about postgresql sequence setval function in the documents

On Wednesday, August 21, 2024, yanliang lei <msdnchina(at)163(dot)com> wrote:

>
>
> in the following example;
> select setval('seq_test',111);
> ---this setval('seq_test',111) : update the current schema's seq_test
> last_value =111
>
> select setval('schemalei.seq_test',222);
> ---this setval('seq_test',111) : update the schemalei schema's
> seq_test last_value =222
>
> but in the setval document(https://www.postgresql.org/docs/current/
> functions-sequence.html), there is no description about it.
>
>
You haven’t indicated what you want done, but the interpretation of the
string literal as a regclass value is discussed in the regclass type
definition. This page rightly does not need to go into detail explaining
how types work, there is other documentation for that. Even the lack of a
link to that page isn’t a problem IMO, though the rarity of the reg* types
could warrant an exception.

David J.