Please consider editing your post and mark it as obsolete instead. Do you want to delete post?
Resolving Oracle synonyms
Permanently deleted user
Created
I am just wondering if you maybe know what is the status of this issue? We heavily depend on public synonyms and developing without autocomplete is quite a pain..
The work for the fix is in progress and it is partly finished. I guess, the new build with the fix can be expected already in the mid of this month (~1weeks).
I have noticed another issue with autocomplete. Problem arises when using autocomplete with live templates. When the template is triggered no suggestion is made for the source table (see pics). After the table is inserted and you move to the select section, sugesstion works as expected.
Can not reproduce issue with completion and Live Templates. Works fine for me:
Doesn't it work only when using Live Templates? Check that you have current schema defined in SQL Console Editor (in my screenshot it is set to public in the upoper right corner). Then IDE will suggest you table names choosing from available in this schema tables.
Leonid I can see that the issue was fixed but in the last version (143.109.1) I still have some problems with autocomplete when I am connected in a different schema than a table that I want to access is located.
Here is the case: - connect to schema A - create table X - grant select on X to B - create public synonym X for A.X - connect to schema B - autocomplete on synonym X will not work despite having all the privilegies
looks like it's a completely different problem. If it's still actual, could you please file a new issue? In that issue please add a screenshot of the list of synonyms in schema B. Thanks
Hello,
The work for the fix is in progress and it is partly finished. I guess, the new build with the fix can be expected already in the mid of this month (~1weeks).
Great, nice to hear that ..
I have noticed another issue with autocomplete. Problem arises when using autocomplete with live templates. When the template is triggered no suggestion is made for the source table (see pics). After the table is inserted and you move to the select section, sugesstion works as expected.
Thanks for the great tool you provided us..
Attachment(s):
000777.png
000776.png
Issue was produced on PostgreSQL 9.4.2 (heroku) but it think the same behaviour occurs on Oracle.
Hello,
we're working on this issue and I exepect we fix it before the next EAP build.
Can not reproduce issue with completion and Live Templates. Works fine for me:
Doesn't it work only when using Live Templates? Check that you have current schema defined in SQL Console Editor (in my screenshot it is set to public in the upoper right corner). Then IDE will suggest you table names choosing from available in this schema tables.
Leonid I can see that the issue was fixed but in the last version (143.109.1) I still have some problems with autocomplete when I am connected in a different schema than a table that I want to access is located.
Here is the case:
- connect to schema A
- create table X
- grant select on X to B
- create public synonym X for A.X
- connect to schema B
- autocomplete on synonym X will not work despite having all the privilegies
Hello Mertez,
looks like it's a completely different problem. If it's still actual, could you please file a new issue? In that issue please add a screenshot of the list of synonyms in schema B.
Thanks