From: Zac Warham <cazwarham@hotmail.com>
To: "pgadmin-support@lists.postgresql.org"
	<pgadmin-support@lists.postgresql.org>
Subject: Forcing autocomplete on keypress
Thread-Topic: Forcing autocomplete on keypress
Thread-Index: AQHbRbegHBNaItTGzkmaxPFLLNgedQ==
Date: Tue, 3 Dec 2024 19:15:11 +0000
Message-ID: 
 <ME3P282MB3328876EA8E6C5A70DC5AF20B7362@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
Accept-Language: en-AU, en-US
Content-Language: en-AU
msip_labels: 
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: ME3P282MB3328:EE_|SY8P282MB5055:EE_
x-ms-office365-filtering-correlation-id: 29f15ede-8f8f-4961-3798-08dd13ceceee
x-microsoft-antispam: 
 BCL:0;ARA:14566002|15080799006|7092599003|9400799027|19110799003|12050799009|461199028|8060799006|15030799003|8062599003|1602099012|102099032|10035399004|440099028|3412199025|4302099013;
x-microsoft-antispam-message-info: 
 =?iso-8859-1?Q?lLyGPCQHe7zAHR6O1lqkG/wuCBT3A2rRC1DBHGXEvUpagkv8W7e7dWaOxC?=
 =?iso-8859-1?Q?j08mJd7pS3Waes22gpm6AYIr3QrXyISo+W+vpDH8zdEX6OZjOeGZ6B00XS?=
 =?iso-8859-1?Q?xDNWkG93V1N7ygQrAaaKZZ/nmOXmj1uzMocKggkmsbrds/UhY4LduNz1jF?=
 =?iso-8859-1?Q?dOXTKa9OomkIHSMRR/AKCN/3v5P75JLpb7NV5gTg81g3Tf24uJkQ6tGY8G?=
 =?iso-8859-1?Q?ZQLo5wv3Lmx2qhKu4IMNDA7wH1vWCJuZF8/+nDawbGjVPfBHV5+KCm8Zf1?=
 =?iso-8859-1?Q?7EOY7LlGGtePVfmI5dtUrdE5vJrgikV+lt1/LDaO+LkMu12qFKJ64ZK3wd?=
 =?iso-8859-1?Q?DcwSXnsn2wswKMGqig+v5VU8IpUFMfy1+0fwrvzSome9GIHddbVkwNLuqE?=
 =?iso-8859-1?Q?Tr/gUx0dPZWvfzAaoq5lMQIIQKs42XQxuAOET2VQlapqBb+T3QYokr4KiI?=
 =?iso-8859-1?Q?sAuTMGuUb+Q6PLYEDneD0iakIkgWwmT2MZ8MspSysWnZ86YEuQ7wpU5dqp?=
 =?iso-8859-1?Q?XndahHLlHewhkJSUqU/g0sLJKJAwv+xlmeP8Jo93K6vQJRzCg+Mi42x0Wo?=
 =?iso-8859-1?Q?h87RjO4catR91vQC7iPLen1nTTQ6uwarYcE5+Kbw1iVb6aHJ1ViFNpg3mX?=
 =?iso-8859-1?Q?WC+TeR/Ol9s5i9p+qwrdPAlbtYLdxTmuX3sydyREhqfTNtezjqTT+Um0GS?=
 =?iso-8859-1?Q?ZIvvyvS1cv5B+8rW5f2xtMtCRehP1A94Ny5F/N3oKDg24IMgtoKtaivrQT?=
 =?iso-8859-1?Q?4WpG490evdBSs1Q5Gc8Bgq3p0q2uuTWx0FTx+T5O0+DKrj1a4UqtUtFIYR?=
 =?iso-8859-1?Q?jurJuO3aaRVnmx/7BSMU0I/YE96K8L2rCXiOYVTzl8xBb1INUht0zRyjAz?=
 =?iso-8859-1?Q?POkCpyVc+MB8/pmdbd3F+E2xSz6LeHXmKvFRs0ycqqimeZptPgm5bH8tHG?=
 =?iso-8859-1?Q?slouy4cglZrqecMsJKwyhfQBMjaEOLCLUrNRf4unrWclv+85M6ZEWz+1sX?=
 =?iso-8859-1?Q?y/65PKGafmsV4gizKm2HAYJ1g6mDcaHKodVJzmPJIUJveEkWHyhpO1R+Am?=
 =?iso-8859-1?Q?Y22wx2SpaNMAEYUQtnC18419OXMMxv5IczYZSSmKXt69xf/UZZRBRwFfV0?=
 =?iso-8859-1?Q?ykYwHwTknv9Y55wRMjmLaS86Cxoy73hcYE+0QOV/axaEGdXRF7ixktsBN9?=
 =?iso-8859-1?Q?frxq5ovkzw0dBs76wZgV7ADtdDPaRC7bncEGrvI8VH5JACu/JXAAtIJARv?=
 =?iso-8859-1?Q?iKD00GG9MQugfNNdEwc4+wpf4zZPybHAvqVIiUcV1X9udPLPHXp2PGbWSa?=
 =?iso-8859-1?Q?QgfW?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?quEnutZwNGx+6wlMU8HFIC+WyLfZNSribqcxARs54vsIZIO+jHHjb7T53H?=
 =?iso-8859-1?Q?7BpKLkQf9JGbcklUMh3yqnEVtPv8YSfrJxkxwWf3MgDeTl0vQwH3GVsqnV?=
 =?iso-8859-1?Q?5tfc0pOOjKmv4vLgoCTYqqFCYcyrzmAqF0eiu3GDZV+fHnBCJ1C/kju0zp?=
 =?iso-8859-1?Q?84R2mOyzm0QpRyO0Xj6OeLXZl2V7XLu3lsEeOD4ZZfdBVWepKKupiSH4iV?=
 =?iso-8859-1?Q?olZXAavw2mw4xO8Xx415+PzUMSyACfuNVp+5YjODzj5jweggdlhA73MVdB?=
 =?iso-8859-1?Q?3ZEpacZvvNF97WVy3vJIu8fA7DKsvxqWY8YkxICq3jDWNkgCLLQAjSJ0dC?=
 =?iso-8859-1?Q?Swwxlmb7ct7F4c8dZLNXi7yJPI1ccvJKqxWpwtvz7EhWYpcs3a8dHY1uQd?=
 =?iso-8859-1?Q?CcRALy+qQVE5dPRYpnxOcvdiAlulxgraV8Bpf5qiNYbusMCYPnhwtnBnzS?=
 =?iso-8859-1?Q?tMWa9fs+ncU/kogzUlACCnbTrqpPpOr26Re69z3iDDd0vlcI5Dwf0bgCXQ?=
 =?iso-8859-1?Q?GVRrqUA/xN9Doxs80KReuH78c637Ndgk0DXijlZuIxDhoizIgwmczWwRid?=
 =?iso-8859-1?Q?NAkkWLxy19ezCi9svOdkoqlsRWxDH3Fu+lhvH2FZHK9uGrvzOcWAPsLBqu?=
 =?iso-8859-1?Q?RMu3TUnkZ4VY8ckOkN/smwnvVC+3XqZuWdsI1CwcU9PpXcDocKyU4Txo0j?=
 =?iso-8859-1?Q?iJaKSq7rIwo6SPCr1oXDEcWC9pLDiiXw9zbM7AAVxGtcSOIyLecFduuhkg?=
 =?iso-8859-1?Q?LZrTqZPNlqDRxZFhXKIdiYddaQiu05ZCri44J5vkWnD91FLx/Nk5HXcMS5?=
 =?iso-8859-1?Q?B69AE+3VHk7KuWiLbxDvSvuN/sOg2aWTcHZE/ExWZGBLhsFaiG4yykNbA3?=
 =?iso-8859-1?Q?OJif85pIqjPKx4gjWSYhUB2Bcy0b3Wp58XwbXv+iVk/OsC/JFxNjYmBmzn?=
 =?iso-8859-1?Q?T/mhxYh6KYZrsLG7nI9Veb8ASR9LLPGR1rSyoTzWfsIy65YWGkzKlfaS15?=
 =?iso-8859-1?Q?ZH7noOIBIiXoKpPGlZY6BgETwMUju89+ap4b6ux5apJyh9eHYyy2GIZkhx?=
 =?iso-8859-1?Q?VLfs/oDhGmdLzsON+prMEuq+1BBqiyJp1hhFHccud4igBlH/AMeN+5l5sN?=
 =?iso-8859-1?Q?rYUHcq7WGYW07wLHuNMgGbUSGgy2+yU543w2lT9lkQ3R2EAZx0TqCEHgMy?=
 =?iso-8859-1?Q?szdTo+WOyJ2OTlMwAzZUEAP/xv93XCeiTsZVKNNMwoZTcjavANzH5FZynj?=
 =?iso-8859-1?Q?RaJcpk1kgqRFJF/v7ohb/BKfW+CRsq0h75nbX/4V0=3D?=
Content-Type: multipart/alternative;
	boundary="_000_ME3P282MB3328876EA8E6C5A70DC5AF20B7362ME3P282MB3328AUSP_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-722bc.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 29f15ede-8f8f-4961-3798-08dd13ceceee
X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Dec 2024 19:15:11.2121
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY8P282MB5055
List-Id: <pgadmin-support.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgadmin-support@lists.postgresql.org>
List-Owner: <mailto:pgadmin-support-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgadmin-support>
Archived-At: 
 <https://www.postgresql.org/message-id/ME3P282MB3328876EA8E6C5A70DC5AF20B7362%40ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_ME3P282MB3328876EA8E6C5A70DC5AF20B7362ME3P282MB3328AUSP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

We have a docker setup for pgadmin and we want to force autocomplete on key=
press at launch (not through the preferences) using an environment variable=
 or config of some sort. I tried modifying the file at https://github.com/p=
gadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqleditor/utils/query_too=
l_preferences.py#L792 and replacing False with True and this works but then=
 breaks postgres in other ways. Is there a proper way of doing this beyond =
modifying this file?


--_000_ME3P282MB3328876EA8E6C5A70DC5AF20B7362ME3P282MB3328AUSP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<span style=3D"font-family: Calibri, Helvetica, sans-serif; font-size: 12pt=
; color: rgb(0, 0, 0);">We have a docker setup for pgadmin and we want to f=
orce autocomplete on keypress at launch (not through the preferences) using=
 an environment variable or config
 of some sort. I tried modifying the file at <a href=3D"https://github.com/=
pgadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqleditor/utils/query_to=
ol_preferences.py#L792" target=3D"_blank" id=3D"OWAee37b897-a86a-9cbf-eec4-=
e5b95d1eda7e" class=3D"OWAAutoLink" title=3D"Protected by Outlook: https://=
github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqleditor/uti=
ls/query_tool_preferences.py#L792. Click or tap to follow the link." rel=3D=
"noopener noreferrer" originalsrc=3D"https://github.com/pgadmin-org/pgadmin=
4/blob/master/web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py#L=
792" data-auth=3D"Verified" data-linkindex=3D"0" data-ogsc=3D"" style=3D"ma=
rgin: 0px; text-align: left;">
https://github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqled=
itor/utils/query_tool_preferences.py#L792</a>&nbsp;and replacing False with=
 True and this works but then breaks postgres in other ways. Is there a pro=
per way of doing this beyond modifying
 this file?</span>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
</body>
</html>

--_000_ME3P282MB3328876EA8E6C5A70DC5AF20B7362ME3P282MB3328AUSP_--