Thread: pgAdmin4 error
Good morning Experts.
After upgrade postgeSQL db from 10.4 to 10.6 and to 11.1 in AWS yesterday, now my pgAdmin gui doesn't work well. I only can preview the information from Tables, views but not trigger functions, functions, and the rest of information under "Schemas" even I can see a plus sign (+) but couldn't expand...
From the Query tool, I can create function successful and when I check back the "function" tab, nothing show. It worked last week with postgreSQL 10.4
![Inline image Inline image](/media/maillist_attaches/pgadmin-support/2019/09/24/1317134842.8127292.1569335133314@mail.yahoo.com/1569335047553blob.jpg)
![Inline image Inline image](/media/maillist_attaches/pgadmin-support/2019/09/24/1317134842.8127292.1569335133314@mail.yahoo.com/1569334968644blob.jpg)
I disconnected the server and reconnected it back and nothing help me to see the information of function/ trigger function.
I can query from the query tool to see the proname and not from the pgAdmin tool.
![Inline image Inline image](/media/maillist_attaches/pgadmin-support/2019/09/24/1317134842.8127292.1569335133314@mail.yahoo.com/1569334932083blob.jpg)
thank you.
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
Attachment
Hi,
On Tue, Sep 24, 2019 at 7:55 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Good morning Experts.After upgrade postgeSQL db from 10.4 to 10.6 and to 11.1 in AWS yesterday, now my pgAdmin gui doesn't work well. I only can preview the information from Tables, views but not trigger functions, functions, and the rest of information under "Schemas" even I can see a plus sign (+) but couldn't expand...From the Query tool, I can create function successful and when I check back the "function" tab, nothing show. It worked last week with postgreSQL 10.4
Restart the pgAdmin server, clear the browser cache and try again.
If the above steps doesn't fix your problem, then provide below details.
- pgAdmin logs. To enable it please refer : https://www.pgadmin.org/faq/#8
- If you find any browser console error then attach them also.
- pgAdmin version
Thanks,
Khushboo
I disconnected the server and reconnected it back and nothing help me to see the information of function/ trigger function.I can query from the query tool to see the proname and not from the pgAdmin tool.thank you.Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
Attachment
Hi,
On Tue, Sep 24, 2019 at 7:55 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Good morning Experts.After upgrade postgeSQL db from 10.4 to 10.6 and to 11.1 in AWS yesterday, now my pgAdmin gui doesn't work well. I only can preview the information from Tables, views but not trigger functions, functions, and the rest of information under "Schemas" even I can see a plus sign (+) but couldn't expand...From the Query tool, I can create function successful and when I check back the "function" tab, nothing show. It worked last week with postgreSQL 10.4
Restart the pgAdmin server, clear the browser cache and try again.
If the above steps doesn't fix your problem, then provide below details.
- pgAdmin logs. To enable it please refer : https://www.pgadmin.org/faq/#8
- If you find any browser console error then attach them also.
- pgAdmin version
Thanks,
Khushboo
I disconnected the server and reconnected it back and nothing help me to see the information of function/ trigger function.I can query from the query tool to see the proname and not from the pgAdmin tool.thank you.Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
Attachment
I did restart the pgAdmin server, disconnect database, clear the browser cache and try again couple times and stil not work. My lead migrate pgAdmin4 version 4 and it works fine.
thank you so much for input.
Have a good day all.
v/r,
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Wednesday, September 25, 2019, 01:19:28 AM EDT, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
Hi,
On Tue, Sep 24, 2019 at 7:55 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Good morning Experts.After upgrade postgeSQL db from 10.4 to 10.6 and to 11.1 in AWS yesterday, now my pgAdmin gui doesn't work well. I only can preview the information from Tables, views but not trigger functions, functions, and the rest of information under "Schemas" even I can see a plus sign (+) but couldn't expand...From the Query tool, I can create function successful and when I check back the "function" tab, nothing show. It worked last week with postgreSQL 10.4
Restart the pgAdmin server, clear the browser cache and try again.
If the above steps doesn't fix your problem, then provide below details.
- pgAdmin logs. To enable it please refer : https://www.pgadmin.org/faq/#8
- If you find any browser console error then attach them also.
- pgAdmin version
Thanks,
Khushboo
I disconnected the server and reconnected it back and nothing help me to see the information of function/ trigger function.I can query from the query tool to see the proname and not from the pgAdmin tool.thank you.Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
Attachment
I did restart the pgAdmin server, disconnect database, clear the browser cache and try again couple times and stil not work. My lead migrate pgAdmin4 version 4 and it works fine.
thank you so much for input.
Have a good day all.
v/r,
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Wednesday, September 25, 2019, 01:19:28 AM EDT, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
Hi,
On Tue, Sep 24, 2019 at 7:55 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Good morning Experts.After upgrade postgeSQL db from 10.4 to 10.6 and to 11.1 in AWS yesterday, now my pgAdmin gui doesn't work well. I only can preview the information from Tables, views but not trigger functions, functions, and the rest of information under "Schemas" even I can see a plus sign (+) but couldn't expand...From the Query tool, I can create function successful and when I check back the "function" tab, nothing show. It worked last week with postgreSQL 10.4
Restart the pgAdmin server, clear the browser cache and try again.
If the above steps doesn't fix your problem, then provide below details.
- pgAdmin logs. To enable it please refer : https://www.pgadmin.org/faq/#8
- If you find any browser console error then attach them also.
- pgAdmin version
Thanks,
Khushboo
I disconnected the server and reconnected it back and nothing help me to see the information of function/ trigger function.I can query from the query tool to see the proname and not from the pgAdmin tool.thank you.Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success