{"action":"created","issue":{"url":"https://api.github.com/repos/SequoiaStudios/DB1/issues/14","labels_url":"https://api.github.com/repos/SequoiaStudios/DB1/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/SequoiaStudios/DB1/issues/14/comments","events_url":"https://api.github.com/repos/SequoiaStudios/DB1/issues/14/events","html_url":"https://github.com/SequoiaStudios/DB1/issues/14","id":115346882,"number":14,"title":"Public schema is not accessible","user":{"login":"Olgagr","id":1297219,"avatar_url":"https://avatars.githubusercontent.com/u/1297219?v=3","gravatar_id":"","url":"https://api.github.com/users/Olgagr","html_url":"https://github.com/Olgagr","followers_url":"https://api.github.com/users/Olgagr/followers","following_url":"https://api.github.com/users/Olgagr/following{/other_user}","gists_url":"https://api.github.com/users/Olgagr/gists{/gist_id}","starred_url":"https://api.github.com/users/Olgagr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Olgagr/subscriptions","organizations_url":"https://api.github.com/users/Olgagr/orgs","repos_url":"https://api.github.com/users/Olgagr/repos","events_url":"https://api.github.com/users/Olgagr/events{/privacy}","received_events_url":"https://api.github.com/users/Olgagr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-05T18:43:06Z","updated_at":"2015-11-09T14:21:10Z","closed_at":null,"body":"I have a problem using this plugin with postgres (Mac, postgres installation: http://postgresapp.com). I setup the connection as follows:\r\n\r\n```\r\n{\r\n\t\"stored_connections\":\r\n\t{\r\n\t\t\"postgres@localhost\":\r\n\t\t{\r\n\t\t\t\"database_type\": \"PostgreSQL\",\r\n\t\t\t\"password\": \"\\\"\",\r\n\t\t\t\"port\": 5432\r\n\t\t}\r\n\t}\r\n}\r\n```\r\n\r\nEverything seems to be working fine, I can see list of databases, I chose one of them. In this database I have tables, for example: users, companies etc. However when I try to execute basic SQL, for example:\r\n\r\n```\r\nselect * from users;\r\n```\r\n\r\nI get an error:\r\n\r\n```\r\nDB1 Error: An error occured while executing a query.\r\n\r\nERROR:  relation \"users\" does not exist\r\nLINE 1: select * from users;\r\n                      ^\r\n\r\nSome additional information about the error is below.\r\n  database: trh_development\r\n  method: Postgresql.exec_sql()\r\n  pg_error_code: 42P01\r\n```\r\n\r\nThe same story for every table in each database. Tables are in public schema, postgres user is the owner of this schema. It seems like the plugin doesn't see the schema. In results.txt  I have information that: \"DB1: Connected to postgres@localhost using database trh_development\". Can anybody help me with this ?"},"comment":{"url":"https://api.github.com/repos/SequoiaStudios/DB1/issues/comments/155076868","html_url":"https://github.com/SequoiaStudios/DB1/issues/14#issuecomment-155076868","issue_url":"https://api.github.com/repos/SequoiaStudios/DB1/issues/14","id":155076868,"user":{"login":"green-arrow","id":2180127,"avatar_url":"https://avatars.githubusercontent.com/u/2180127?v=3","gravatar_id":"","url":"https://api.github.com/users/green-arrow","html_url":"https://github.com/green-arrow","followers_url":"https://api.github.com/users/green-arrow/followers","following_url":"https://api.github.com/users/green-arrow/following{/other_user}","gists_url":"https://api.github.com/users/green-arrow/gists{/gist_id}","starred_url":"https://api.github.com/users/green-arrow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/green-arrow/subscriptions","organizations_url":"https://api.github.com/users/green-arrow/orgs","repos_url":"https://api.github.com/users/green-arrow/repos","events_url":"https://api.github.com/users/green-arrow/events{/privacy}","received_events_url":"https://api.github.com/users/green-arrow/received_events","type":"User","site_admin":false},"created_at":"2015-11-09T14:21:10Z","updated_at":"2015-11-09T14:21:10Z","body":"This is happening for me as well. When I initially downloaded this package it worked fine, but now I'm running into this issue.\r\n\r\nAlso, when launching a stored connection, I now get an error `database <user_name> does not exist`. I'm thinking something must have happened during a recent update of this package."}}