Re: INFORMATION_SCHEMA.routine_column_usage

2023-11-30 Thread Peter Eisentraut
On 29.11.23 15:01, Peter Eisentraut wrote: Here https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html it is stated that "The view |routine_column_usage| is meant to identify all columns that a

Re: Delete description of trigger file

2023-11-30 Thread Michael Paquier
On Fri, Dec 01, 2023 at 11:54:14AM +0900, Shinya Kato wrote: > later disconnected, the standby goes back to step 1 and tries to > restore the file from the archive again. This loop of retries from the > archive, pg_wal, and via streaming replication goes > on until the server > -

Delete description of trigger file

2023-11-30 Thread Shinya Kato
Hi, Standby database promotion by trigger file creation is no longer supported from v16, but its description is remained. So, I created a patch. Do you think? -- Regards, Shinya Kato NTT DATA GROUP CORPORATIONdiff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgm

Re: Typo in '8.5. Date/Time Types' v16

2023-11-30 Thread Tom Lane
PG Doc comments form writes: > In the interval example outputs, for postgres and postgres_verbose. > It says mons instead of months. That is in fact the datatype's output format. regression=# show intervalstyle; IntervalStyle --- postgres (1 row) regression=# select '2 month'::in

Restore to a new database from a backup (.tar) generated from

2023-11-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/app-pgrestore.html Description: After creating a new database in postgreSQL : CREATE DATABASE x; I dump it in a .tar file:

Typo in '8.5. Date/Time Types' v16

2023-11-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-datetime.html Description: Hello, In the interval example outputs, for postgres and postgres_verbose. It says mons instead of months.