question about "vacuum full" command

2024-08-16 Thread yanliang lei
"vacuum full" command is : vacumm full command in the psql, for example:
postgres=# vacuum full;
VACUUM
postgres=# 


in my question,vacumm full command is not "vacuum full " command


I want to know :vacumm full command ( not "vacuum full " command) 
will influence which table?all tables in current database?


but in the docs(https://www.postgresql.org/docs/current/routine-vacuuming.html 
), there is no description about  vacumm full command ( not "vacuum full 
" command) will influence which table?


I think the following is perfect in the document : adding  the description  
about  vacumm full command  ( not "vacuum full " command) will 
influence which table.

Re: question about "vacuum full" command

2024-08-16 Thread David G. Johnston
On Friday, August 16, 2024, yanliang lei  wrote:
>
>
> I think the following is perfect in the document : adding  the
> description  about  vacumm full command  ( not "vacuum full "
> command) will influence which table.
>

Every command has a reference page in the docs where details like this are
noted.

https://www.postgresql.org/docs/current/sql-vacuum.html

David J.


Re: Change detail text in last example of 43.5.3. Executing a Command with a Single-Row Result

2024-08-16 Thread Bruce Momjian
On Tue, Jul 16, 2024 at 09:11:35AM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/16/plpgsql-statements.html
> Description:
> 
> The last example in the chapter uses a named parameter "username". As a
> result, the detail message should use "username" instead of "$1" to match
> the runtime behavior.
> 
> I suggest to change this line
> 
> DETAIL:  parameters: $1 = 'nosuchuser'
> 
> to 
> 
> DETAIL:  parameters: username = 'nosuchuser'

Wow, this error goes all the way back to Postgres 12, which is our
earliest supported release.  I have patched all our supported releases
with this fix.  Thanks.

-- 
  Bruce Momjian  https://momjian.us
  EDB  https://enterprisedb.com

  Only you can decide what is important to you.