pgsql: Fix pg_dump's failure to honor dependencies of SQL functions.

2023-06-04 Thread Tom Lane
Fix pg_dump's failure to honor dependencies of SQL functions. A new-style SQL function can contain a parse-time dependency on a unique index, much as views and matviews can (such cases arise from GROUP BY and ON CONFLICT clauses, for example). To dump and restore such a function successfully, pg_d

pgsql: Fix misuse of pg_log_info() for details/hints.

2023-06-04 Thread Tom Lane
Fix misuse of pg_log_info() for details/hints. Two places in pg_dump_sort.c were using pg_log_info() to add more details to a message printed with pg_log_warning(). This is bad, because at default verbosity level we would print the warning line but not the details. One should use pg_log_warning_d

pgsql: Fix misuse of pg_log_info() for details/hints.

2023-06-04 Thread Tom Lane
Fix misuse of pg_log_info() for details/hints. Two places in pg_dump_sort.c were using pg_log_info() to add more details to a message printed with pg_log_warning(). This is bad, because at default verbosity level we would print the warning line but not the details. One should use pg_log_warning_d

pgsql: Fix pg_dump's failure to honor dependencies of SQL functions.

2023-06-04 Thread Tom Lane
Fix pg_dump's failure to honor dependencies of SQL functions. A new-style SQL function can contain a parse-time dependency on a unique index, much as views and matviews can (such cases arise from GROUP BY and ON CONFLICT clauses, for example). To dump and restore such a function successfully, pg_d

pgsql: Fix pg_dump's failure to honor dependencies of SQL functions.

2023-06-04 Thread Tom Lane
Fix pg_dump's failure to honor dependencies of SQL functions. A new-style SQL function can contain a parse-time dependency on a unique index, much as views and matviews can (such cases arise from GROUP BY and ON CONFLICT clauses, for example). To dump and restore such a function successfully, pg_d

pgsql: Doc: explain about dependency tracking for new-style SQL functio

2023-06-04 Thread Tom Lane
Doc: explain about dependency tracking for new-style SQL functions. 5.14 Dependency Tracking was not updated when we added new-style SQL functions. Improve that. Noted by Sami Imseih. Back-patch to v14 where new-style SQL functions came in. Discussion: https://postgr.es/m/2c1933ab-c2f8-499b-9d

pgsql: Doc: explain about dependency tracking for new-style SQL functio

2023-06-04 Thread Tom Lane
Doc: explain about dependency tracking for new-style SQL functions. 5.14 Dependency Tracking was not updated when we added new-style SQL functions. Improve that. Noted by Sami Imseih. Back-patch to v14 where new-style SQL functions came in. Discussion: https://postgr.es/m/2c1933ab-c2f8-499b-9d

pgsql: Doc: explain about dependency tracking for new-style SQL functio

2023-06-04 Thread Tom Lane
Doc: explain about dependency tracking for new-style SQL functions. 5.14 Dependency Tracking was not updated when we added new-style SQL functions. Improve that. Noted by Sami Imseih. Back-patch to v14 where new-style SQL functions came in. Discussion: https://postgr.es/m/2c1933ab-c2f8-499b-9d

pgsql: Doc: unify use of timestamp with time zone vs timestamptz

2023-06-04 Thread David Rowley
Doc: unify use of timestamp with time zone vs timestamptz For pg_stat_all_tables, last_vacuum, last_autovacuum and co all used the full "timestamp with time zone" type name. For consistency, make the newly added "last_seq_scan" also use the full type name instead of "timestamptz". Author: Noriyo