Completion error occurs.

[unikuragit]

Completion error occurs.

[lighttiger2505]

The error occurs because the database table and column information cannot be cached due to the inability to connect to the database. Please review the database settings.

The connection settings are incorrect. The following is correct. workspace_config is missing.

autocmd User lsp_setup call lsp#register_server({
\   'name': 'sqls',
\   'cmd': {server_info->['sqls']},
\   'whitelist': ['sql'],
\   'workspace_config': {
\     'sqls': {
\       'connections': [
\         {
\           'driver': 'postgresql',
\           'dataSourceName': 'host=LOCAL-IP port=5432 dbname=GTX1 user=postgres password=PASSWORD sslmode=disable',
\         },
\       ],
\     },
\   },
\ })

[unikuragit]

Thank you for your reply.
I'm sorry, I overlooked it.
I tried again after changing the settings, but it was still an error.
sqls seems to die.
Only sqls is used for the LSP provider.

05/15/20 16:32:35:["s:on_stdout client option on_notification() error","Vim(call):E631: ch_sendraw(): write failed","function 294_out_cb[2]..293_on_stdout[71]..211_on_notification[17]..211_handle_initialize[25]..292_callback[1]..292_next[9]..16[1]..211_ensure_conf[14]..292_callback[1]..292_next[9]..17[1]..211_ensure_open[25]..211_send_notification[7]..lsp#client#send_notification[1]..293_lsp_send[36]..async#job#send[1]..294_job_send, line 6"]
05/15/20 16:32:35:["<---(stderr)",1,"sqls",["2020/05/15 16:32:35 sqls: reading on stdin, writing on stdout",""]]
05/15/20 16:32:35:["s:on_exit",1,"sqls","exited",1]

I think the DB connection information is correct.
The location of the cause is not clear, but we will report it.

[unikuragit]

I solved my problem.
The cause was that the PGCLIENTENCODING environment variable was set to 'SJIS' because of the encoding of the connection destination PostgreSQL.
It worked when I changed PGCLIENTENCODING = 'UNICODE'.
Thank you for your support.