On Mon, Nov 6, 2023 at 4:16 PM Corey Huinker <corey.huin...@gmail.com> wrote: >> >> >> Yeah, that use makes sense as well, and if so then postgres_fdw would likely >> need to be aware of the appropriate query for several versions back - they >> change, not by much, but they do change. So now we'd have each query text in >> three places: a system view, postgres_fdw, and the bin/scripts pre-upgrade >> program. So I probably should consider the best way to share those in the >> codebase. >> > > Attached is v2 of this patch.
While applying Patch, I noticed few Indentation issues: 1) D:\Project\Postgres>git am v2-0003-Add-pg_import_rel_stats.patch .git/rebase-apply/patch:1265: space before tab in indent. errmsg("invalid statistics format, stxndeprs must be array or null"); .git/rebase-apply/patch:1424: trailing whitespace. errmsg("invalid statistics format, stxndistinct attnums elements must be strings, but one is %s", .git/rebase-apply/patch:1315: new blank line at EOF. + warning: 3 lines add whitespace errors. Applying: Add pg_import_rel_stats(). 2) D:\Project\Postgres>git am v2-0004-Add-pg_export_stats-pg_import_stats.patch .git/rebase-apply/patch:282: trailing whitespace. const char *export_query_v14 = .git/rebase-apply/patch:489: trailing whitespace. const char *export_query_v12 = .git/rebase-apply/patch:648: trailing whitespace. const char *export_query_v10 = .git/rebase-apply/patch:826: trailing whitespace. .git/rebase-apply/patch:1142: trailing whitespace. result = PQexec(conn, warning: squelched 4 whitespace errors warning: 9 lines add whitespace errors. Applying: Add pg_export_stats, pg_import_stats. Thanks and Regards, Shubham Khanna.