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

From: "yanliang lei" <msdnchina(at)163(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re:Re: Supplements and suggestions and about postgresql sequence setval function in the documents
Date: 2024-08-21 23:40:44
Message-ID: 11dd05aa.24b.19177506992.Coremail.msdnchina@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(dot)g(dot)johnston(at)gmail(dot)com> 写道:

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.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2024-08-21 23:57:55 Re: Re: Supplements and suggestions and about postgresql sequence setval function in the documents
Previous Message Tom Lane 2024-08-21 21:33:31 Re: Typo on 2.3. PostgreSQL