column auto complete

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
itaishavit
Posts: 3
Joined: Wed 20 Feb 2019 12:01

column auto complete

Post by itaishavit » Wed 20 Feb 2019 12:06

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

.jp
Devart Team
Posts: 326
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: column auto complete

Post by .jp » Tue 26 Feb 2019 07:47

Hello,

Thanks for the post.
Could you please provide us queries you typed and a screenshot indicated the problem.

Best Regards.

itaishavit
Posts: 3
Joined: Wed 20 Feb 2019 12:01

Re: column auto complete

Post by itaishavit » Sun 03 Mar 2019 06:38

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]

alexa
Devart Team
Posts: 2782
Joined: Fri 24 Jun 2011 14:17

Re: column auto complete

Post by alexa » Wed 13 Mar 2019 10:42

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

brentpham
Posts: 1
Joined: Tue 19 Mar 2019 08:53

Re: column auto complete

Post by brentpham » Tue 19 Mar 2019 09:03

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
Last edited by brentpham on Mon 22 Apr 2019 09:45, edited 2 times in total.

alexa
Devart Team
Posts: 2782
Joined: Fri 24 Jun 2011 14:17

Re: column auto complete

Post by alexa » Tue 19 Mar 2019 13:10

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?

itaishavit
Posts: 3
Joined: Wed 20 Feb 2019 12:01

Re: column auto complete

Post by itaishavit » Tue 19 Mar 2019 13:14

Yes, both tables are suggested, but columns only in one of them

alexa
Devart Team
Posts: 2782
Joined: Fri 24 Jun 2011 14:17

Re: column auto complete

Post by alexa » Mon 25 Mar 2019 07:57

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 .

alexa
Devart Team
Posts: 2782
Joined: Fri 24 Jun 2011 14:17

Re: column auto complete

Post by alexa » Tue 26 Mar 2019 14:41

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 .

DORRIE
Posts: 1
Joined: Sat 27 Jul 2019 10:38

Re: column auto complete

Post by DORRIE » Wed 31 Jul 2019 12:56

Decent, need to accomplish something like this with mine.

Post Reply