Page 1 of 1
column auto complete
Posted: Wed 20 Feb 2019 12:06
by itaishavit
Hi there,
i'm using dbforge postgres to connect to amazon redshift.
The column auto complete stopped working for only 2-3 tables out of the entire DB, while still working for others.
Additionally, querying these tables still works fine, it's only the retrieving of the columns that doesn't work.
Any ideas?
thanks
Re: column auto complete
Posted: Tue 26 Feb 2019 07:47
by .jp
Hello,
Thanks for the post.
Could you please provide us queries you typed and a screenshot indicated the problem.
Best Regards.
Re: column auto complete
Posted: Sun 03 Mar 2019 06:38
by itaishavit
hi,
it happens it all types of queries.
in the screenshot below you can see in a simple select
- in the top table all columns are suggested in auto complete
- in the bottom table no suggestions.
both from the same DB
thanks
[
https://snag.gy/EbZUnY.jpg]
Re: column auto complete
Posted: Wed 13 Mar 2019 10:42
by alexa
dbForge uses Devart's ADO.NET provider dotConnect for PostgreSQL. EF Core is ORM that, in this case, also works through Devart's ADO.NET provider dotConnect for PostgreSQL.
Please check that you are using the same connection string in both cases.
In case of dotConnect for PostgreSQL, please check the connection string used in runtime with another our product dbMonitor
https://www.devart.com/dotconnect/postg ... nitor.html
Re: column auto complete
Posted: Tue 19 Mar 2019 09:03
by brentpham
Re: column auto complete
Posted: Tue 19 Mar 2019 13:10
by alexa
I am using the same connection string in both cases.
The problem still happens
Could you please let us know whether you checked with dbMonitor
https://www.devart.com/dotconnect/postg ... nitor.html that the same connection string is used in both cases?
Could you please let us know if both the tables on the screenshot you provided get suggested in the completion list?
Re: column auto complete
Posted: Tue 19 Mar 2019 13:14
by itaishavit
Yes, both tables are suggested, but columns only in one of them
Re: column auto complete
Posted: Mon 25 Mar 2019 07:57
by alexa
Unfortunately, we still were not able to reproduce this issue.
Could you please provide us a video demonstrating this?
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
Re: column auto complete
Posted: Tue 26 Mar 2019 14:41
by alexa
Could you please provide us the result of the following query:
Code: Select all
SELECT pc.oid, pc.relname, COUNT(pa.attname)
FROM pg_class pc
LEFT JOIN pg_attribute pa ON pa.attrelid = pc.oid
WHERE pc.relkind = 'v'
GROUP BY pc.oid, pc.relname
HAVING COUNT(pa.attname) = 0;
Also, you could try the 'Refresh Local Cache' command available in the 'SQL Complete' section of the main menu.
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
Re: column auto complete
Posted: Wed 31 Jul 2019 12:56
by DORRIE
Decent, need to accomplish something like this with mine.