Re: 'pg_global' cannot be used as default_tablespace.

2023-11-01 Thread Bruce Momjian
On Wed, Nov 1, 2023 at 07:12:48PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Wed, Nov 1, 2023 at 06:32:37PM -0400, Tom Lane wrote: > >> But it *is* permissible, unless we add code to reject it during > >> SET as Bruce mentioned. Which seems fairly pointless to me. It's not > >> like

Re: 'pg_global' cannot be used as default_tablespace.

2023-11-01 Thread Tom Lane
Bruce Momjian writes: > On Wed, Nov 1, 2023 at 06:32:37PM -0400, Tom Lane wrote: >> But it *is* permissible, unless we add code to reject it during >> SET as Bruce mentioned. Which seems fairly pointless to me. It's not >> like there is anything unclear about the CREATE TABLE error message. >

Re: 'pg_global' cannot be used as default_tablespace.

2023-11-01 Thread Bruce Momjian
On Wed, Nov 1, 2023 at 06:32:37PM -0400, Tom Lane wrote: > "David G. Johnston" writes: > > On Wednesday, November 1, 2023, Bruce Momjian wrote: > >> Did you want an error from the SET command? > > > That would probably be a decent addition but the request was for us to add > > “it is not permis

Re: Typo in "43.9.1. Reporting Errors and Messages"?

2023-11-01 Thread Michael Paquier
On Wed, Nov 01, 2023 at 09:18:47AM +0900, Michael Paquier wrote: > So you mean something like the attached then? Fixed that with f8b96c211da0 down to 11, in time for next week's release set. -- Michael signature.asc Description: PGP signature

Re: 'pg_global' cannot be used as default_tablespace.

2023-11-01 Thread Tom Lane
"David G. Johnston" writes: > On Wednesday, November 1, 2023, Bruce Momjian wrote: >> Did you want an error from the SET command? > That would probably be a decent addition but the request was for us to add > “it is not permissible to specify the pg_global tablespace for either > default_tablesp

Re: 'pg_global' cannot be used as default_tablespace.

2023-11-01 Thread David G. Johnston
On Wednesday, November 1, 2023, Bruce Momjian wrote: > On Tue, Nov 10, 2020 at 08:28:08AM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/13/bug-reporting.html > > Description: > > > > Tablesp

Re: 'pg_global' cannot be used as default_tablespace.

2023-11-01 Thread Bruce Momjian
On Tue, Nov 10, 2020 at 08:28:08AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/bug-reporting.html > Description: > > Tablespace 'pg_global' is one of the two auto-generated tablespace by > in

Re: Documentation of return values of range functions lower and upper

2023-11-01 Thread Bruce Momjian
On Wed, Nov 1, 2023 at 09:40:43PM +0100, Laurenz Albe wrote: > > Yes, I agree this documentation needs help. > > > > For upper/lower(), it is clear that the documentation is better saying > > "unspecified" rather than infinite. The fact that upper/lower_inf() > > returns false for +/-Infinity is

Re: Documentation of return values of range functions lower and upper

2023-11-01 Thread Laurenz Albe
On Wed, 2023-11-01 at 16:28 -0400, Bruce Momjian wrote: > On Wed, Nov 18, 2020 at 05:28:44PM +0100, Laurenz Albe wrote: > > On Wed, 2020-11-18 at 22:49 +0900, Fujii Masao wrote: > > > On 2020/11/12 17:14, Laurenz Albe wrote: > > > > On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: > > > > > >

Re: Document target_role param of ALTER DEFAULT PRIVILEGES

2023-11-01 Thread Laurenz Albe
On Wed, 2023-11-01 at 13:09 -0400, Bruce Momjian wrote: > On Thu, Feb 18, 2021 at 08:16:13AM +0100, Laurenz Albe wrote: > > On Wed, 2021-02-17 at 15:08 -0500, Jordi Gutiérrez Hermoso wrote: > > > I just had a confusing moment trying to figure out why my roles > > > weren't creating tables the way I

Re: Documentation of return values of range functions lower and upper

2023-11-01 Thread Bruce Momjian
On Wed, Nov 18, 2020 at 05:28:44PM +0100, Laurenz Albe wrote: > On Wed, 2020-11-18 at 22:49 +0900, Fujii Masao wrote: > > On 2020/11/12 17:14, Laurenz Albe wrote: > > > > > On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: > > > > > Table 9.54 in page > > > > > https://www.postgresql.org/docs

Re: Document target_role param of ALTER DEFAULT PRIVILEGES

2023-11-01 Thread Bruce Momjian
On Thu, Feb 18, 2021 at 08:16:13AM +0100, Laurenz Albe wrote: > On Wed, 2021-02-17 at 15:08 -0500, Jordi Gutiérrez Hermoso wrote: > > I just had a confusing moment trying to figure out why my roles > > weren't creating tables the way I was expecting them to. I didn't > > understand what the `target