What I want to express is：
There is no description in the document that the schema name can be included
before the sequence name
在 2024-08-21 21:01:35，"David G. Johnston" <david.g.johns...@gmail.com> 写道：
On Wednesday, August 21, 2024, yanliang lei <msdnch...@163.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.
