column auto complete
-
- Posts: 3
- Joined: Wed 20 Feb 2019 12:01
column auto complete
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
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
Hello,
Thanks for the post.
Could you please provide us queries you typed and a screenshot indicated the problem.
Best Regards.
Thanks for the post.
Could you please provide us queries you typed and a screenshot indicated the problem.
Best Regards.
-
- Posts: 3
- Joined: Wed 20 Feb 2019 12:01
Re: column auto complete
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]
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
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
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
I am using the same connection string in both cases.
The problem still happens.
FIY: the same connection string is used in both cases in dbMonitor.
_____________________________________________
About me:
best air purifier|best large room air purifier|best air purifier for office|best air purifier for bedroom|best air purifier for allergies|best air purifier for pets|best air purifier for smoke|best air purifier for mold|best air purifier for dust
The problem still happens.
FIY: the same connection string is used in both cases in dbMonitor.
_____________________________________________
About me:
best air purifier|best large room air purifier|best air purifier for office|best air purifier for bedroom|best air purifier for allergies|best air purifier for pets|best air purifier for smoke|best air purifier for mold|best air purifier for dust
Last edited by brentpham on Mon 22 Apr 2019 09:45, edited 2 times in total.
Re: column auto complete
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?I am using the same connection string in both cases.
The problem still happens
Could you please let us know if both the tables on the screenshot you provided get suggested in the completion list?
-
- Posts: 3
- Joined: Wed 20 Feb 2019 12:01
Re: column auto complete
Yes, both tables are suggested, but columns only in one of them
Re: column auto complete
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 .
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
Could you please provide us the result of the following query:
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 .
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;
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
Re: column auto complete
Decent, need to accomplish something like this with mine.