Re: The pg_stop_backup will return one row with three values.

2021-12-20 Thread Dave Cramer
On Mon, 20 Dec 2021 at 08:12, Julien Rouhaud wrote: > On Mon, Dec 20, 2021 at 8:19 PM Dave Cramer > wrote: > > > > On Mon, 20 Dec 2021 at 07:03, Laurenz Albe > wrote: > >> > >> On Sun, 2021-12-19 at 21:08 +, PG Doc comments form wrote: > >> > Page: https://www.postgresql.org/docs/14/continu

Re: The pg_stop_backup will return one row with three values.

2021-12-20 Thread Julien Rouhaud
On Mon, Dec 20, 2021 at 8:19 PM Dave Cramer wrote: > > On Mon, 20 Dec 2021 at 07:03, Laurenz Albe wrote: >> >> On Sun, 2021-12-19 at 21:08 +, PG Doc comments form wrote: >> > Page: https://www.postgresql.org/docs/14/continuous-archiving.html >> > Description: >> > >> > It appears that this ma

Re: The pg_stop_backup will return one row with three values.

2021-12-20 Thread Michael Paquier
On Mon, Dec 20, 2021 at 07:19:32AM -0500, Dave Cramer wrote: > The docs say it returns 3 values ? They do. Here is the relevant part: https://www.postgresql.org/docs/devel/functions-admin.html#FUNCTIONS-ADMIN-BACKUP "The result of the function is a single record. The lsn column holds the backup's

Re: The pg_stop_backup will return one row with three values.

2021-12-20 Thread Dave Cramer
On Mon, 20 Dec 2021 at 07:03, Laurenz Albe wrote: > On Sun, 2021-12-19 at 21:08 +, PG Doc comments form wrote: > > Page: https://www.postgresql.org/docs/14/continuous-archiving.html > > Description: > > > > It appears that this may be out of date. > > > > pg_stop_backup > > >

Unnest discards rows with empty or null arrays

2021-12-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-srf.html Description: https://www.postgresql.org/message-id/17340-74d17bbe94cb4190%40postgresql.org This behaviour is unexpected from an external perspective but after speaking

Re: The pg_stop_backup will return one row with three values.

2021-12-20 Thread Laurenz Albe
On Sun, 2021-12-19 at 21:08 +, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/14/continuous-archiving.html > Description: > > It appears that this may be out of date. > > pg_stop_backup > --- >  (0/20