Re: SQL command : ALTER DATABASE OWNER TO

On Tue, Mar 8, 2022 at 7:39 AM Bruce Momjian wrote: > On Tue, Mar 8, 2022 at 10:50:38AM +0100, gp...@free.fr wrote: > > > > Hello, > > > > for this "ALTER DATABASE" form, it should be mentioned that after > execution of the command, > > the old database owner loses all his privileges on it

list all the Boolean flags in pg_class that are maintained lazily.

PostgreSQL: Documentation: 14: 52.11. pg_class > Several of the Boolean flags in pg_class are maintained lazily: they are > guaranteed to be true if that's the correct state, but may not be reset to > false immediately when the

Re: SQL command : ALTER DATABASE OWNER TO

On Tue, Mar 8, 2022 at 10:50:38AM +0100, gp...@free.fr wrote: > > Hello, > > for this "ALTER DATABASE" form, it should be mentioned that after execution > of the command, > the old database owner loses all his privileges on it (even connection) > although it might > still owns schemas or

Missing information about CREATE TRIGGER on temporary tables

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createtrigger.html Description: To be confirmed by the developer community... The reference page about CREATE TRIGGER should indicate if it's allowed to create triggers on temp

Re: Missing information about CREATE TRIGGER on temporary tables

On Tue, Mar 8, 2022 at 9:25 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/sql-createtrigger.html > Description: > > To be confirmed by the developer community... > The reference page about CREATE

Re: Missing information about CREATE TRIGGER on temporary tables

PG Doc comments form writes: > The reference page about CREATE TRIGGER should indicate if it's allowed to > create triggers on temp tables. > This seems to be the supported, but I was wondering what happens with the > trigger name when created on a temp table. The page already says The name

Re: Missing tags ALTER ROUTINE and DROP ROUTINE in Event Trigger Firing Matrix

Hi Leslie, On Sat, Mar 05, 2022 at 10:15:33AM +, PG Doc comments form wrote: > "ALTER ROUTINE" and "DROP ROUTINE" are not listed in the "Event Trigger > Firing Matrix" documentation page, even though these tags seem supported > from PostgreSQL 11 onwards. > > It would be really useful to

Re: add free space map link in pg_freespacemap page

On Tue, Mar 08, 2022 at 06:34:34PM +0900, Dong Wook Lee wrote: > Patch looks good to me. Okay, applied then. -- Michael signature.asc Description: PGP signature

Update wording of INSERT ON CONFLICT "rows proposed for insertion"

Hey, I suggest a minor rewording of: https://www.postgresql.org/docs/devel/sql-insert.html Current: "The SET and WHERE clauses in ON CONFLICT DO UPDATE have access to the existing row using the table's name (or an alias), and to [rows] proposed for insertion using the special excluded table."

SQL command : ALTER DATABASE OWNER TO

Hello, for this "ALTER DATABASE" form, it should be mentioned that after execution of the command, the old database owner loses all his privileges on it (even connection) although it might still owns schemas or objects (tables, index,...) inside it. Thanks in advance to add this important

Re: add free space map link in pg_freespacemap page

Patch looks good to me. 2022년 3월 8일 (화) 오후 3:17, Michael Paquier 님이 작성: > On Tue, Mar 08, 2022 at 09:31:49AM +0900, Dong Wook Lee wrote: > > I don't know about it, so should I use at FSM for all the > > acronyms in the section dedicated to acronyms? > > Yes, I would do that on consistency