search

kostafey / ejc-sql

Emacs SQL client uses Clojure JDBC.
284 stars 31 forks source link

complete some functions for PostgreSQL is wrong #127

Closed stardiviner closed 4 years ago

stardiviner commented 4 years ago

For example, pg_typeof function in PostgreSQL is not shown in ejc-sql candidates. It only shown not exist function pg_type. Maybe my PostgreSQL driver version is old?

Also I found ejc-sql can't complete some table columns. For example, I have a table named cities which has column names city, temp, date. But ejc-sql can't complete city after SELECT.

stardiviner commented 4 years ago

Gentl ping of this issue.

kostafey commented 4 years ago

@stardiviner, please try with the latest commit. Also, please note that column autocompletion for SELECT queries is restricted by a single table. E.g. this case SELECT | FROM table is ok, but here autocompletion will not work: SELECT | FROM table1, table2. Use aliases (or full table names) in this case: SELECT t1.| FROM table1 t1, table2 t2 or SELECT table1.| FROM table1, table2.

stardiviner commented 4 years ago

I tested the latest commit. It works fine now. Thanks a lot @kostafey