{"action":"opened","issue":{"url":"https://api.github.com/repos/ODM2/ODM2PythonAPI/issues/12","labels_url":"https://api.github.com/repos/ODM2/ODM2PythonAPI/issues/12/labels{/name}","comments_url":"https://api.github.com/repos/ODM2/ODM2PythonAPI/issues/12/comments","events_url":"https://api.github.com/repos/ODM2/ODM2PythonAPI/issues/12/events","html_url":"https://github.com/ODM2/ODM2PythonAPI/issues/12","id":119411787,"number":12,"title":"Problem creating connection to PostgreSQL database","user":{"login":"emiliom","id":742403,"avatar_url":"https://avatars.githubusercontent.com/u/742403?v=3","gravatar_id":"","url":"https://api.github.com/users/emiliom","html_url":"https://github.com/emiliom","followers_url":"https://api.github.com/users/emiliom/followers","following_url":"https://api.github.com/users/emiliom/following{/other_user}","gists_url":"https://api.github.com/users/emiliom/gists{/gist_id}","starred_url":"https://api.github.com/users/emiliom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/emiliom/subscriptions","organizations_url":"https://api.github.com/users/emiliom/orgs","repos_url":"https://api.github.com/users/emiliom/repos","events_url":"https://api.github.com/users/emiliom/events{/privacy}","received_events_url":"https://api.github.com/users/emiliom/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-11-30T03:16:39Z","updated_at":"2015-11-30T03:16:39Z","closed_at":null,"body":"After installing ODM2PythonAPI using the overhauled setup I described in issue #11 (with the `setup_em` branch I've created), I got an error trying to make a test connection to one of my local PostgreSQL ODM2 databases:\r\n```Python\r\nfrom odm2api.ODMconnection import dbconnection\r\nfrom odm2api.ODM2.services import *\r\n\r\nsession_factory = dbconnection.createConnection('postgresql', 'localhost', 'odm2_rivers', \r\n                                                 'myuser', 'mypwd')\r\n```\r\n```\r\n**** {'engine': 'postgresql', 'password': 'mypwd', 'db': 'odm2_rivers', 'user': 'myuser', 'address': 'localhost'}\r\n****** postgresql+psycopg2://myuser:mypwd@localhost/odm2_rivers\r\nConnection was unsuccessful  (psycopg2.ProgrammingError) relation \"Variables\" does not exist\r\nLINE 2: FROM \"Variables\"\r\n```\r\n\r\nThe messages `relation \"Variables\" does not exist` and `LINE 2: FROM \"Variables\"` suggest that it's trying to issue a query using a case-sensitive (double-quoted) table name for \"Variables\". I was able to [track the error to probably this line in odm2api/ODMconnection.py,](https://github.com/ODM2/ODM2PythonAPI/blob/setup_em/odm2api/ODMconnection.py#L101) but I wasn't able to go beyond that.\r\n\r\n@sreeder, can you look into it? I can help fix it if it's a case issue and you can point me to where the problem is. BTW, this may be related to the [case handling issues discussed a few months ago in issue #2](https://github.com/ODM2/ODM2PythonAPI/issues/2). Back then I was able to change the code and get it to work for me with postgresql, but that was before you overhauled the case handling."}}