Re: DWIM mode for psql

Hi Thomas,

Thanks for working on this.

On Mon, Apr 1, 2019 at 5:53 Thomas Munro <thomas(dot)munro(at)gmail(dot)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

>