From: yanliang lei <msdnchina@163.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re:Re: Supplements and suggestions and about postgresql sequence setval function in the documents
Date: Thu, 22 Aug 2024 07:40:44 +0800 (CST)
Message-ID: <11dd05aa.24b.19177506992.Coremail.msdnchina@163.com> (raw)
In-Reply-To: <CAKFQuwbBxpaSkwdEwvfzWeFCTeT1rGBhHLC66u-wZ=wFJ8c4Rg@mail.gmail.com>
References: <33f1f47d.9f8f.19174e48943.Coremail.msdnchina@163.com>
<CAKFQuwbBxpaSkwdEwvfzWeFCTeT1rGBhHLC66u-wZ=wFJ8c4Rg@mail.gmail.com>
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.johnston@gmail.com> 写道：
On Wednesday, August 21, 2024, yanliang lei <msdnchina@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: msdnchina@163.com, david.g.johnston@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re:Re: Supplements and suggestions and about postgresql sequence setval function in the documents
In-Reply-To: <11dd05aa.24b.19177506992.Coremail.msdnchina@163.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox