Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

relation doesn't exist error postgreSQL -- yes it does! #49

Closed
ortonomy opened this issue Jun 5, 2018 · 7 comments
Closed

relation doesn't exist error postgreSQL -- yes it does! #49

ortonomy opened this issue Jun 5, 2018 · 7 comments

Comments

@ortonomy
Copy link

ortonomy commented Jun 5, 2018

Extension can see my database, connect, even see the tables. But when I make a query, I get a relation doesn't exist error.

image

FYI, the tables are in a named schema in db, not on public.

i.e. I'm connecting to myDB.myschema not just myDB...

@ortonomy
Copy link
Author

ortonomy commented Jun 5, 2018

Potentially related to #24 -- this also contains a period selector.

@ortonomy
Copy link
Author

ortonomy commented Jun 5, 2018

It seems like the database selector works once to switch to dotted schema, and after one query, it resets.

@ortonomy
Copy link
Author

ortonomy commented Jul 3, 2018

@kasecato

@Bajdzis
Copy link
Owner

Bajdzis commented Jul 8, 2018

Thanks for issue ;) I have two additional question:

What are your versions PG server? You could send your incorrect query?

@ortonomy
Copy link
Author

ortonomy commented Jul 8, 2018

output from psql --version
psql (PostgreSQL) 9.6.9

I didn't make a query. I used the GUI:

image

image

kasecato added a commit to kasecato/vscode-database that referenced this issue Jul 14, 2018
@kasecato
Copy link
Contributor

Hi @ortonomy ,

Thank you for your reporting to me. I tried to fix this issue...

@Bajdzis , I just PR of this issue, please check it. 🙇

@Bajdzis
Copy link
Owner

Bajdzis commented Jul 15, 2018

@kasecato
Thank you for your help ;)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants