Setting up postgres-language-server?

[magthe]

Has anyone set up postgres-language-server for use with lsp-mode?

[jcs090218]

Implemented in #4755. Can you try the latest version? 🤔 Thanks!

[magthe]

I've updated and installed postgrestools but when I M-x lsp Messages says

LSP :: The following servers support current file but automatic download is disabled: sql-ls postgres-ls

and lsp-log says

Command "sqls" is not present on the path.

I had to (setopt lsp-postgres-server-path "postgrestools") to make it start properly, despite the variable being documented as "for development only".

[jcs090218]

I had to (setopt lsp-postgres-server-path "postgrestools") to make it start properly, despite the variable being documented as "for development

There are multiple language servers for SQL. Make sure you choose the correct one.

[magthe]

I only have one installed though, so I thought it'd be picked without configuration.