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

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

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

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

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

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: 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 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