diff options
author | Michael Paquier <michael@paquier.xyz> | 2025-09-01 09:02:03 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2025-09-01 09:02:03 +0900 |
commit | 36aed19fd99021ad9f727e4fd4bceb086a7cf54d (patch) | |
tree | ae8295135f0e375dd1bf6d330ef433ac8397dd56 /src/include/regex/regexp.h | |
parent | 317c117d6d23cff98c1259701495422bc952a7dd (diff) |
postgres_fdw: Use psql variables for connection parametersHEADorigin/masterorigin/HEADmaster
Several statements need to reference the current connection's current
database name and current port value. Until now, this has been
accomplished by creating dynamic SQL statements inside of a DO block,
which is not as easy to parse. It also takes away some of the
granularity of any error messages that might occur, making debugging
harder.
By capturing the connection-specific settings into psql variables, it
becomes possible to write simpler SQL statements for the FDW objects.
This eliminates most of DO blocks used in this test, making it a bit
more readable and shorter.
Author: Author: Corey Huinker <corey.huinker@gmail.com>
Discussion: https://postgr.es/m/CADkLM=cpUiJ3QF7aUthTvaVMmgQcm7QqZBRMDLhBRTR+gJX-Og@mail.gmail.com
Diffstat (limited to 'src/include/regex/regexp.h')
0 files changed, 0 insertions, 0 deletions