v3.3 Auto complete broken

[Hibbard, Brandon]

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]

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, <

Post by Hibbard, Brandon
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

[Hibbard, Brandon]

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?

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.

Thanks,
Brandon

From: Akshay Joshi <***@enterprisedb.com>
Sent: Monday, September 10, 2018 12:05 PM
To: Hibbard, Brandon <***@zimmerbiomet.com>
Cc: pgAdmin Support <pgadmin-***@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, <***@zimmerbiomet.com<mailto:***@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]

Hi Brandon


On Wed, Oct 17, 2018 at 6:22 PM Hibbard, Brandon <

Post by Hibbard, Brandon
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.

Post by Hibbard, Brandon
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

Post by Hibbard, Brandon
Thanks,
Brandon
*Sent:* Monday, September 10, 2018 12:05 PM
*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, <
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

[Aditya Toshniwal]

Hi,

Post by Akshay Joshi
Hi Brandon
On Wed, Oct 17, 2018 at 6:22 PM Hibbard, Brandon <

Post by Hibbard, Brandon
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.

Post by Hibbard, Brandon
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.

Post by Akshay Joshi

Post by Hibbard, Brandon
Thanks,
Brandon
*Sent:* Monday, September 10, 2018 12:05 PM
*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, <
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: [phone]Mobile: [phone]*

[Hibbard, Brandon]

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 <***@enterprisedb.com>
Sent: Thursday, October 18, 2018 5:48 AM
To: Akshay Joshi <***@enterprisedb.com>
Cc: Hibbard, Brandon <***@zimmerbiomet.com>; pgadmin-***@postgresql.org
Subject: Re: v3.3 Auto complete broken

Hi,

On Thu, Oct 18, 2018 at 11:57 AM Akshay Joshi <***@enterprisedb.com<mailto:***@enterprisedb.com>> wrote:
Hi Brandon


On Wed, Oct 17, 2018 at 6:22 PM Hibbard, Brandon <***@zimmerbiomet.com<mailto:***@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 <***@enterprisedb.com<mailto:***@enterprisedb.com>>
Sent: Monday, September 10, 2018 12:05 PM
To: Hibbard, Brandon <***@zimmerbiomet.com<mailto:***@zimmerbiomet.com>>
Cc: pgAdmin Support <pgadmin-***@postgresql.org<mailto:pgadmin-***@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, <***@zimmerbiomet.com<mailto:***@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

[Image removed by sender.]

Phone: [phone]
Mobile: [phone]

[Aditya Toshniwal]

Hi Brandon,



On Thu, Oct 18, 2018 at 9:11 PM Hibbard, Brandon <

Post by Hibbard, Brandon
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?

We need to analyse the issue further and for that you have to raise a
ticket https://redmine.postgresql.org/projects/pgadmin4.

And regarding the indentation problem, we have a ticket -
https://redmine.postgresql.org/issues/3583 and will be fixed in upcoming
releases.

Post by Hibbard, Brandon
Brandon
*Sent:* Thursday, October 18, 2018 5:48 AM
*Subject:* Re: v3.3 Auto complete broken
Hi,
On Thu, Oct 18, 2018 at 11:57 AM Akshay Joshi <
Hi Brandon
On Wed, Oct 17, 2018 at 6:22 PM Hibbard, Brandon <
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
*Sent:* Monday, September 10, 2018 12:05 PM
*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, <
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 *
*[image: Image removed by sender.]*
*Phone: [phone] Mobile: [phone]*
--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"