Hi, thank you for this great software!
I'm not implying that support for old servers should be added or
announced, of course. But in my organization we are doomed to keep
some legacy servers (for now), certainly not something we are proud
of. When attempting to connect to those servers I get an error stating
that the configuration parameter "bytea_output" doesn't exist and
connection is then closed. You can figure how *old* I'm talking about
now.
So, instead of using the "SET configuration_parameter = value" I
changed it to "UPDATE pg_settings ..." (which is valid according to
the docs) to make it silently not set that parameter if it's not found
in the server. I also have some v11 clusters and can confirm using
"SHOW bytea_output" that it's still correctly set to "escape". But if
I access the same cluster from within "psql" program I get "hex".
Thank you very much.
--- pgadmin/utils/driver/psycopg2/connection.py.orig
+++ pgadmin/utils/driver/psycopg2/connection.py
@@ -405,7 +405,7 @@
status = _execute(cur, "SET DateStyle=ISO; "
"SET client_min_messages=notice;"
- "SET bytea_output=escape;"
+ "UPDATE pg_settings SET setting = 'escape' WHERE name = 'bytea_output';"
"SET client_encoding='{0}';"
.format(postgres_encoding))
