Re: pgsql: Avoid doing catalog lookups in postgres_fdw's conversion_error_c

2021-10-06 Thread Andrey Borodin
> 6 окт. 2021 г., в 21:36, Tom Lane написал(а): > Will fix. Thanks Tom! Best regards, Andrey Borodin.

pgsql: Improve order in file

2021-10-06 Thread Peter Eisentraut
Improve order in file Move support functions for new PublicationTable node to more sensible locations in the files. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d942887039a608c91084a942fe10571c6f6be35a Modified Files -- src/backend/nodes/copyfuncs.c

pgsql: Refactor per-destination file rotation in logging collector

2021-10-06 Thread Michael Paquier
Refactor per-destination file rotation in logging collector stderr and csvlog have been using duplicated code when it came to the rotation of their file by size, age or if forced by a user request (pg_ctl logrotate or the SQL function pg_rotate_logfile). The main difference between both is that s

pgsql: Fix null-pointer crash in postgres_fdw's conversion_error_callba

2021-10-06 Thread Tom Lane
Fix null-pointer crash in postgres_fdw's conversion_error_callback. Commit c7b7311f6 adjusted conversion_error_callback to always use information from the query's rangetable, to avoid doing catalog lookups in an already-failed transaction. However, as a result of the utterly inadequate documentat

pgsql: Fix null-pointer crash in postgres_fdw's conversion_error_callba

2021-10-06 Thread Tom Lane
Fix null-pointer crash in postgres_fdw's conversion_error_callback. Commit c7b7311f6 adjusted conversion_error_callback to always use information from the query's rangetable, to avoid doing catalog lookups in an already-failed transaction. However, as a result of the utterly inadequate documentat

pgsql: Fix null-pointer crash in postgres_fdw's conversion_error_callba

2021-10-06 Thread Tom Lane
Fix null-pointer crash in postgres_fdw's conversion_error_callback. Commit c7b7311f6 adjusted conversion_error_callback to always use information from the query's rangetable, to avoid doing catalog lookups in an already-failed transaction. However, as a result of the utterly inadequate documentat

pgsql: Fix null-pointer crash in postgres_fdw's conversion_error_callba

2021-10-06 Thread Tom Lane
Fix null-pointer crash in postgres_fdw's conversion_error_callback. Commit c7b7311f6 adjusted conversion_error_callback to always use information from the query's rangetable, to avoid doing catalog lookups in an already-failed transaction. However, as a result of the utterly inadequate documentat

pgsql: Fix null-pointer crash in postgres_fdw's conversion_error_callba

2021-10-06 Thread Tom Lane
Fix null-pointer crash in postgres_fdw's conversion_error_callback. Commit c7b7311f6 adjusted conversion_error_callback to always use information from the query's rangetable, to avoid doing catalog lookups in an already-failed transaction. However, as a result of the utterly inadequate documentat

pgsql: Fix null-pointer crash in postgres_fdw's conversion_error_callba

2021-10-06 Thread Tom Lane
Fix null-pointer crash in postgres_fdw's conversion_error_callback. Commit c7b7311f6 adjusted conversion_error_callback to always use information from the query's rangetable, to avoid doing catalog lookups in an already-failed transaction. However, as a result of the utterly inadequate documentat

pgsql: Fix null-pointer crash in postgres_fdw's conversion_error_callba

2021-10-06 Thread Tom Lane
Fix null-pointer crash in postgres_fdw's conversion_error_callback. Commit c7b7311f6 adjusted conversion_error_callback to always use information from the query's rangetable, to avoid doing catalog lookups in an already-failed transaction. However, as a result of the utterly inadequate documentat

Re: pgsql: Avoid doing catalog lookups in postgres_fdw's conversion_error_c

2021-10-06 Thread Tom Lane
Andrey Borodin writes: > 5 окт. 2021 г., в 22:08, Tom Lane написал(а): >> Could we have a test case for that please? It seems to be related >> to ANALYZE, but I'm unexcited about reverse-engineering the details. > Sure, I'll compose a repro a bit later. Ah, never mind, I found I can duplicate

pgsql: Doc: improve timezone/README's recipe for tracking Windows zones

2021-10-06 Thread Tom Lane
Doc: improve timezone/README's recipe for tracking Windows zones. We should now cite CLDR as primary reference for the zone name mapping. Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/db692b0c84908b

pgsql: Fix corner-case loss of precision in numeric_power().

2021-10-06 Thread Dean Rasheed
Fix corner-case loss of precision in numeric_power(). This fixes a loss of precision that occurs when the first input is very close to 1, so that its logarithm is very small. Formerly, during the initial low-precision calculation to estimate the result weight, the logarithm was computed to a loca

pgsql: Fix corner-case loss of precision in numeric_power().

2021-10-06 Thread Dean Rasheed
Fix corner-case loss of precision in numeric_power(). This fixes a loss of precision that occurs when the first input is very close to 1, so that its logarithm is very small. Formerly, during the initial low-precision calculation to estimate the result weight, the logarithm was computed to a loca

pgsql: Fix corner-case loss of precision in numeric_power().

2021-10-06 Thread Dean Rasheed
Fix corner-case loss of precision in numeric_power(). This fixes a loss of precision that occurs when the first input is very close to 1, so that its logarithm is very small. Formerly, during the initial low-precision calculation to estimate the result weight, the logarithm was computed to a loca

pgsql: Fix corner-case loss of precision in numeric_power().

2021-10-06 Thread Dean Rasheed
Fix corner-case loss of precision in numeric_power(). This fixes a loss of precision that occurs when the first input is very close to 1, so that its logarithm is very small. Formerly, during the initial low-precision calculation to estimate the result weight, the logarithm was computed to a loca

pgsql: Fix corner-case loss of precision in numeric_power().

2021-10-06 Thread Dean Rasheed
Fix corner-case loss of precision in numeric_power(). This fixes a loss of precision that occurs when the first input is very close to 1, so that its logarithm is very small. Formerly, during the initial low-precision calculation to estimate the result weight, the logarithm was computed to a loca

pgsql: Fix corner-case loss of precision in numeric_power().

2021-10-06 Thread Dean Rasheed
Fix corner-case loss of precision in numeric_power(). This fixes a loss of precision that occurs when the first input is very close to 1, so that its logarithm is very small. Formerly, during the initial low-precision calculation to estimate the result weight, the logarithm was computed to a loca

pgsql: Fix corner-case loss of precision in numeric_power().

2021-10-06 Thread Dean Rasheed
Fix corner-case loss of precision in numeric_power(). This fixes a loss of precision that occurs when the first input is very close to 1, so that its logarithm is very small. Formerly, during the initial low-precision calculation to estimate the result weight, the logarithm was computed to a loca