pgAdmin4 v4.20 "View/Edit Data --> First 100 rows" on table pop up "column gdp.attrnums does not exist" error when connecting to Greenplum Community v6.7.0

From: Brandon Hsu <brandon(dot)hsu(at)omniwaresoft(dot)com(dot)tw>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pgAdmin4 v4.20 "View/Edit Data --> First 100 rows" on table pop up "column gdp.attrnums does not exist" error when connecting to Greenplum Community v6.7.0
Date: 2020-04-23 09:14:22
Message-ID: CA+JYH_2Zu960P5rXpAfAhjJoNcOL11Nvmi1v1j6hM0syBFFFpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, Team,

I recently test pgAdmin4 connecting to Greenplum Community v6.x.

When I right click on a greenplum table,an error pops up.
[image: image.png]

And inDB log shows the following error:

*[gpadmin(at)mdw logs]$ grep ERR
/data/master/gpseg-1/pg_log/gpdb-2020-04-23_162203.csv2020-04-23
16:55:13.545913
CST,"gpadmin","mypower",p54588,th2089666688,"10.52.14.184","60932",2020-04-23
16:49:04 CST,0,con321,cmd43,seg-1,,,,sx1,"ERROR","42703","column
gdp.attrnums does not exist",,,,,,"SELECT *,[gpadmin(at)mdw logs]$*

Is it possible to fix this error message?

Best Regards.
--

徐嘉群 / Brandon Hsu 0912423813

歐立威科技 Omniwaresoft Technology Inc.

Tel: (02)-2558-2656 #117 Fax:02-2558-5559

E-mail : brandon(dot)hsu(at)omniwaresoft(dot)com(dot)tw

部落格 : http://ravenonhill.blogspot.tw/

Address: 10349台北市大同區鄭州路 87 號 10 樓

--
----------------------------------------------------------------------------------------------------------------------------------------------------

本信件(包括任何附件)為機密信件。若您並非指定收信人,嚴禁複製、傳送、公開或使用其所載的全部或部份資料,任何對於本信件未經授權之使用或散播可能帶有法律責任。

若您偶然獲得此郵件,請回信或立即以電話通知寄件人並且從您的電腦系統中刪除本信件及所有附件,謝謝。
The
information in this
e-mail may be confidential; it is intended for use
solely by the
individual or entity named as the recipient hereof.
Disclosure, copying,
distribution, or use of the contents of this e-mail
by persons other than
the intended recipient may violate applicable
laws and if you have
received this e-mail in error, please delete the
original message and
notify us by collect call immediately. Thank you.

----------------------------------------------------------------------------------------------------------------------------------------------------

Browse pgsql-admin by date

  From Date Subject
Next Message Ashok kumar Mani 2020-04-24 03:59:42 RE: Help needed for replication issue
Previous Message Prince Pathria 2020-04-23 09:00:03 Re: Help needed for replication issue