Thread: v3.3 Auto complete broken

Hi Brandon

On Wed, Oct 17, 2018 at 6:22 PM Hibbard, Brandon <Brandon.Hibbard@zimmerbiomet.com> wrote:

Hello Akshay and pgAdmin support,

 

I am on version 3.4 now, and the auto complete is listing the tables in the schema, but it is not listing the fields in the table.  Is this still an open bug? 

    Are you talking about listing the fields in the table for auto complete? If yes then It's working for me. To see the fields in the table using auto complete you will have to create  an alias for the table name. Please see the attached screenshots. 

 

I have also noticed an odd formatting behavior when there are nested functions.  An example is Upper(trim(b.source)).  At the end of this line, if you enter down, the auto indent is way off and continues to be for the following lines.  If you add a space between the last two parenthesis like Upper(trim(b.source) ), the auto indent works as expected.

   For this please create a new RM  

 

Thanks,

Brandon

 

From: Akshay Joshi <akshay.joshi@enterprisedb.com>
Sent: Monday, September 10, 2018 12:05 PM
To: Hibbard, Brandon <Brandon.Hibbard@zimmerbiomet.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: v3.3 Auto complete broken

 

Hi Brandon

 

RM 3630 has already been there and I have sent the patch on pgadmin hackers where objects belongs to schema other than pg_catalog and public are not listed. You can apply that patch and test it.

 

On Mon, 10 Sep 2018, 21:26 Hibbard, Brandon, <Brandon.Hibbard@zimmerbiomet.com> wrote:

Hello,

 

I installed pgAdmin 4 v3.3 today and autocomplete isn’t working correctly. It does not list the tables in a schema or the fields in the table.  Is this a bug or have I done something wrong?

 

Thanks

Brandon

--

Akshay Joshi

Sr. Software Architect

Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

Hello Aditya,

 

That is interesting.  I tested this on my local Postgres 10, and the fields do populate.  When I am connected to my Postgres 9.5 server, the fields do not populate.  They populated in pgAdmin 4 version 3.2 for this same database, so I am not sure what is wrong.  Any ideas?

 

Brandon

 

From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Thursday, October 18, 2018 5:48 AM
To: Akshay Joshi <akshay.joshi@enterprisedb.com>
Cc: Hibbard, Brandon <Brandon.Hibbard@zimmerbiomet.com>; pgadmin-support@postgresql.org
Subject: Re: v3.3 Auto complete broken

 

Hi,

 

On Thu, Oct 18, 2018 at 11:57 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:

Hi Brandon

 

 

On Wed, Oct 17, 2018 at 6:22 PM Hibbard, Brandon <Brandon.Hibbard@zimmerbiomet.com> wrote:

Hello Akshay and pgAdmin support,

 

I am on version 3.4 now, and the auto complete is listing the tables in the schema, but it is not listing the fields in the table.  Is this still an open bug? 

 

    Are you talking about listing the fields in the table for auto complete? If yes then It's working for me. To see the fields in the table using auto complete you will have to create  an alias for the table name. Please see the attached screenshots. 

 

I have also noticed an odd formatting behavior when there are nested functions.  An example is Upper(trim(b.source)).  At the end of this line, if you enter down, the auto indent is way off and continues to be for the following lines.  If you add a space between the last two parenthesis like Upper(trim(b.source) ), the auto indent works as expected.

 

   For this please create a new RM  

We have a RM raised for this problem - https://redmine.postgresql.org/issues/3583. It will be fixed when CodeMirror's next version is available as it is fixed there.

 

Thanks,

Brandon

 

From: Akshay Joshi <akshay.joshi@enterprisedb.com>
Sent: Monday, September 10, 2018 12:05 PM
To: Hibbard, Brandon <Brandon.Hibbard@zimmerbiomet.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: v3.3 Auto complete broken

 

Hi Brandon

 

RM 3630 has already been there and I have sent the patch on pgadmin hackers where objects belongs to schema other than pg_catalog and public are not listed. You can apply that patch and test it.

 

On Mon, 10 Sep 2018, 21:26 Hibbard, Brandon, <Brandon.Hibbard@zimmerbiomet.com> wrote:

Hello,

 

I installed pgAdmin 4 v3.3 today and autocomplete isn’t working correctly. It does not list the tables in a schema or the fields in the table.  Is this a bug or have I done something wrong?

 

Thanks

Brandon

 

--

Akshay Joshi

Sr. Software Architect

 

 

Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

 

--

Thanks and Regards,

Aditya Toshniwal

Software Engineer | EnterpriseDB Software Solutions | Pune

"Don't Complain about Heat, Plant a tree"