autocompletion for sql tables not working in preview 1.2.1015 for Postgresql databases

[rdataforge]

testing rstudio preview 1.2.1015 on windows, following the blog post indications for SQL here:

https://blog.rstudio.com/2018/10/02/rstudio-1-2-preview-sql/

the issue is I can not fire up autocompletion for tables. I can use it for databases but is not working for tables. I click on tab but only databases are shown.

any hint?

[andresrcs]

I filed an issue on github about this a time ago, and was solved on a daily build, I don't remember which one exactly but the latest has the fix for sure, although, autocompletion is not prefect for postgresql mostly due to its more complex object structure.

[jcblum]

If you have a link to the issue you filed, that would be helpful! (I tried searching but wasn’t turning up anything that looked right).

[andresrcs]

I forgot that I didn't file the issue myself, I made a post Here and then kevinushey opened one for me.

[jcblum]

Thanks! That makes more sense

For anybody else who might come along, here’s the issue:

improve SQL autocompletion's understanding of schemas