Skip to content

SQL widget problem #51

@MatejKovacic

Description

@MatejKovacic

I am using Ubuntu 16.04.1 LTS and installed Orange with the following commands:
sudo apt-get install python3-pip
sudo pip3 install orange3
sudo apt install python3-pyqt5
sudo apt install python3-pyqt5.qtwebkit
sudo apt install python3-pyqt5.qtsvg
sudo pip3 install psycopg2

Then I run orange-canvas and add SQL widget. It draws warning icon and when I open it, it says:
invalid port number: "None"

This can be solved if you enter this to the "server field":
127.0.0.1:5432

My suggestion is if there is no port specified from the user, Orange should use default port (5432), or - there should be another field named port in SQL widget.

And there is another problem: SQL widget says "permission denied to create extension "tsm_system_time".
The problem is, if I connect to psql as postgres user and say CREATE EXTENSION tsm_system_time;, I got an error: extension "tsm_system_time" already exists.

It seems this extension is already installed. Any idea how to solve this?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions