Hi Thomas, Thanks for working on this.
On Mon, Apr 1, 2019 at 5:53 Thomas Munro <thomas.mu...@gmail.com> wrote: Hello, > > Building on the excellent work begun by commit e529cd4ffa60, I would > like to propose a do-what-I-mean mode for psql. Please find a POC > patch attached. It works like this: > > postgres=# select datnaam from pg_database where ooid = 12917; > ERROR: column "datnaam" does not exist > LINE 1: select datnaam from pg_database where ooid = 12917; > ^ > HINT: Perhaps you meant to reference the column "pg_database.datname". > postgres=# YES > datname > ---------- > postgres > (1 row) > > As you can see, by "shouting" a new keyword at the computer, it will > take its own hint and run the corrected query. To avoid having to do > this in two steps, you can also shout the whole query for the same > effect: > > postgres=# SELECT DATNAAM FROM PG_DATABASE WHERE OOID = 12917; > datname > ---------- > postgres > (1 row) Neat. The next version will be able to fix permissions problems and override > errors automatically as follows, though that is proving trickier to > get working. Example: > > postgres=# SUDO DROP TABLE PG_DATABASS; > NO CARRIER Have you tried rebooting the machine? Thanks, Amit >