pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co 7+ messages / 1 participants [nested] [flat]
* pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co @ 2022-07-17 21:28 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2022-07-17 21:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org postgres_fdw: set search_path to 'pg_catalog' while deparsing constants. The motivation for this is to ensure successful transmission of the values of constants of regconfig and other reg* types. The remote will be reading them with search_path = 'pg_catalog', so schema qualification is necessary when referencing objects in other schemas. Per bug #17483 from Emmanuel Quincerot. Back-patch to all supported versions. (There's some other stuff to do here, but it's less back-patchable.) Discussion: https://postgr.es/m/1423433.1652722406@sss.pgh.pa.us Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/0a7ccee8fe9ffaff09ad45f4890a3457c69e80b7 Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 20 ++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 8 ++++++++ contrib/postgres_fdw/sql/postgres_fdw.sql | 9 +++++++++ 3 files changed, 37 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co @ 2022-07-17 21:28 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2022-07-17 21:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org postgres_fdw: set search_path to 'pg_catalog' while deparsing constants. The motivation for this is to ensure successful transmission of the values of constants of regconfig and other reg* types. The remote will be reading them with search_path = 'pg_catalog', so schema qualification is necessary when referencing objects in other schemas. Per bug #17483 from Emmanuel Quincerot. Back-patch to all supported versions. (There's some other stuff to do here, but it's less back-patchable.) Discussion: https://postgr.es/m/1423433.1652722406@sss.pgh.pa.us Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b8032f4816c3a5bd178841492d8f249d8b4572ba Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 20 ++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 8 ++++++++ contrib/postgres_fdw/sql/postgres_fdw.sql | 9 +++++++++ 3 files changed, 37 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co @ 2022-07-17 21:28 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2022-07-17 21:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org postgres_fdw: set search_path to 'pg_catalog' while deparsing constants. The motivation for this is to ensure successful transmission of the values of constants of regconfig and other reg* types. The remote will be reading them with search_path = 'pg_catalog', so schema qualification is necessary when referencing objects in other schemas. Per bug #17483 from Emmanuel Quincerot. Back-patch to all supported versions. (There's some other stuff to do here, but it's less back-patchable.) Discussion: https://postgr.es/m/1423433.1652722406@sss.pgh.pa.us Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/810bcbd383ab615a24ea972db0e1157572f3a12c Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 20 ++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 8 ++++++++ contrib/postgres_fdw/sql/postgres_fdw.sql | 9 +++++++++ 3 files changed, 37 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co @ 2022-07-17 21:28 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2022-07-17 21:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org postgres_fdw: set search_path to 'pg_catalog' while deparsing constants. The motivation for this is to ensure successful transmission of the values of constants of regconfig and other reg* types. The remote will be reading them with search_path = 'pg_catalog', so schema qualification is necessary when referencing objects in other schemas. Per bug #17483 from Emmanuel Quincerot. Back-patch to all supported versions. (There's some other stuff to do here, but it's less back-patchable.) Discussion: https://postgr.es/m/1423433.1652722406@sss.pgh.pa.us Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/6230bd7df4ce1f04a350ab490a528148d25f5df9 Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 20 ++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 8 ++++++++ contrib/postgres_fdw/sql/postgres_fdw.sql | 9 +++++++++ 3 files changed, 37 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co @ 2022-07-17 21:28 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2022-07-17 21:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org postgres_fdw: set search_path to 'pg_catalog' while deparsing constants. The motivation for this is to ensure successful transmission of the values of constants of regconfig and other reg* types. The remote will be reading them with search_path = 'pg_catalog', so schema qualification is necessary when referencing objects in other schemas. Per bug #17483 from Emmanuel Quincerot. Back-patch to all supported versions. (There's some other stuff to do here, but it's less back-patchable.) Discussion: https://postgr.es/m/1423433.1652722406@sss.pgh.pa.us Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/288e499ba817ccb364b9bc826a4470f03ca23b72 Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 20 ++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 8 ++++++++ contrib/postgres_fdw/sql/postgres_fdw.sql | 9 +++++++++ 3 files changed, 37 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co @ 2022-07-17 21:28 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2022-07-17 21:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org postgres_fdw: set search_path to 'pg_catalog' while deparsing constants. The motivation for this is to ensure successful transmission of the values of constants of regconfig and other reg* types. The remote will be reading them with search_path = 'pg_catalog', so schema qualification is necessary when referencing objects in other schemas. Per bug #17483 from Emmanuel Quincerot. Back-patch to all supported versions. (There's some other stuff to do here, but it's less back-patchable.) Discussion: https://postgr.es/m/1423433.1652722406@sss.pgh.pa.us Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/94bcb48ab53b2d3b322acc541efe02d9702bb105 Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 20 ++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 8 ++++++++ contrib/postgres_fdw/sql/postgres_fdw.sql | 9 +++++++++ 3 files changed, 37 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co @ 2022-07-17 21:28 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2022-07-17 21:28 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org postgres_fdw: set search_path to 'pg_catalog' while deparsing constants. The motivation for this is to ensure successful transmission of the values of constants of regconfig and other reg* types. The remote will be reading them with search_path = 'pg_catalog', so schema qualification is necessary when referencing objects in other schemas. Per bug #17483 from Emmanuel Quincerot. Back-patch to all supported versions. (There's some other stuff to do here, but it's less back-patchable.) Discussion: https://postgr.es/m/1423433.1652722406@sss.pgh.pa.us Branch ------ REL_10_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/26c9e1bd88467f59b2550bf8e5fa8f7357bf77f2 Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 20 ++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 8 ++++++++ contrib/postgres_fdw/sql/postgres_fdw.sql | 9 +++++++++ 3 files changed, 37 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2022-07-17 21:28 UTC | newest] Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-07-17 21:28 pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co Tom Lane <tgl@sss.pgh.pa.us> 2022-07-17 21:28 pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co Tom Lane <tgl@sss.pgh.pa.us> 2022-07-17 21:28 pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co Tom Lane <tgl@sss.pgh.pa.us> 2022-07-17 21:28 pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co Tom Lane <tgl@sss.pgh.pa.us> 2022-07-17 21:28 pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co Tom Lane <tgl@sss.pgh.pa.us> 2022-07-17 21:28 pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co Tom Lane <tgl@sss.pgh.pa.us> 2022-07-17 21:28 pgsql: postgres_fdw: set search_path to 'pg_catalog' while deparsing co Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox