| From: | solai v <solai(dot)cdac(at)gmail(dot)com> |
|---|---|
| To: | Álvaro Rodríguez <alvaro(at)datadoghq(dot)com> |
| Cc: | surya poondla <suryapoondla4(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Improving psql autocompletion for SET LOCAL / SET SESSION |
| Date: | 2026-06-16 12:07:20 |
| Message-ID: | CAF0whufR5-i8wyQG8vjMvDjQRP5RSf5AtETQnEf1-VwomBnVFQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Álvaro,
I tested v2 in my environment.
The regression reported in v1 appears to be resolved. I can now see
the previously missing completions such as AUTHORIZATION and
CHARACTERISTICS AS TRANSACTION under SET SESSION, along with the
variable completions.
I also tested prefix completion:
SET SESSION A suggests AUTHORIZATION
SET SESSION C suggests CHARACTERISTICS AS TRANSACTION
SET SESSION R suggests ROLE
SET LOCAL R suggests ROLE
SET LOCAL continues to show configuration variable completions as expected.
I agree with your observation that the special syntax is somewhat
hidden among the large list of variable completions, but the
completions are available and working correctly.
Regards,
Solai
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ajit Awekar | 2026-06-16 12:14:27 | Continuous re-validation of session credentials |
| Previous Message | Etsuro Fujita | 2026-06-16 12:04:37 | Re: use of SPI by postgresImportForeignStatistics |