search

mtxr / SublimeText-SQLTools

SQLTools for Sublime Text 3
https://code.mteixeira.dev/SublimeText-SQLTools/
GNU General Public License v3.0
177 stars 40 forks source link

Unable to execute with postgresql #200

Closed ketric closed 6 years ago

ketric commented 6 years ago

This issue template helps us understand your SQLTools issues better.

You don't need to stick to this template, but please try to guide us to reproduce the errors or understand your feature requests.

Before submitting an issue, please consider these things first:

  • Are you running the latest version? If not, try to upgrade.
  • Did you check the Setup Guide?
  • Did you check the logs in console (Ctrl+` or select View → Show Console)?
  • Yes to everything

    Issue Type

Feature Request | Bug/Error | x Question | Other

Description

Im trying to execute, but get KeyError : 'psql'. My current setup connection: { "connections": { "Connection PostgreSQL": { "type" : "psql", "host" : "127.0.0.1", "port" : 5432, "database": "test", "username": "postgres", // password is optional (setup "pgpass.conf" file instead) "password": "root", "encoding": "utf-8" } }, "default": null }

Version

You can get this information by executing ST: About from Sublime Command Palette.

Steps to Reproduce (For bugfixes)

  1. ctrl + e, ctrl +e
  2. view console
  3. message is shown.

Expected behavior: For it to execute

Actual behavior: Traceback (most recent call last): File "C:\Program Files\Sublime Text 3\sublimeplugin.py", line 1036, in run return self.run() File "C:\Users\kenny\AppData\Roaming\Sublime Text 3\Packages\SQLTools\SQLTools.py", line 482, in run ST.selectConnection() File "C:\Users\kenny\AppData\Roaming\Sublime Text 3\Packages\SQLTools\SQLTools.py", line 359, in selectConnection ST.connectionList = getConnections() File "C:\Users\kenny\AppData\Roaming\Sublime Text 3\Packages\SQLTools\SQLTools.py", line 96, in getConnections connectionsObj[name] = createConnection(name, config, settings=settings.all()) File "C:\Users\kenny\AppData\Roaming\Sublime Text 3\Packages\SQLTools\SQLTools.py", line 112, in createConnection newConnection = Connection(name, config, settings=settings) File "C:\Users\kenny\AppData\Roaming\Sublime Text 3\Packages\SQLTools\SQLToolsAPI\Connection.py", line 71, in init self.cli = settings.get('cli')[options['type']] KeyError: 'psql'