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

2024-08-21 Thread David Rowley
On Thu, 22 Aug 2024 at 11:41, yanliang lei wrote: > What I want to express is: >There is no description in the document that the schema name can be > included before the sequence name I'm not to sure there is any problem here. If you look at the final paragraph in: https://www.postgresql.org

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

2024-08-21 Thread David G. Johnston
On Wed, Aug 21, 2024 at 4:41 PM yanliang lei wrote: > What I want to express is: >There is no description in the document that the schema name can be > included before the sequence name > > > Correct. It is here: All of the OID alias types for objects that are grouped by namespace accept sc

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

2024-08-21 Thread yanliang lei
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" 写道: On Wednesday, August 21, 2024, yanliang lei wrote: in the following example; select setval('seq_

Re: Typo on 2.3. PostgreSQL

2024-08-21 Thread Tom Lane
PG Doc comments form writes: > In https://www.postgresql.org/docs/16/history.html#HISTORY-POSTGRESQL, > Chapter 2.3. PostgreSQL is written in first sentence: "By 1996, it became > clear that the name “Postgres95” would not stand the test of time." > I think there should be "the rest of time" inste

Typo on 2.3. PostgreSQL

2024-08-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/history.html Description: In https://www.postgresql.org/docs/16/history.html#HISTORY-POSTGRESQL, Chapter 2.3. PostgreSQL is written in first sentence: "By 1996, it became clear that the na

Rsync access to https://www.postgresql.org/docs/ ?

2024-08-21 Thread hubert depesz lubaczewski
Hi, would it be possible to get access to whole docs site, for all versions, via rsync? I'd like have a copy of docs for my grepping purposes, and would like to refresh it every so often, but preferably without need to redownload the whole thing. Best regards, depesz

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

2024-08-21 Thread David G. Johnston
On Wednesday, August 21, 2024, yanliang lei 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

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

2024-08-21 Thread yanliang lei
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