From: | <Harald(dot)Immerheiser(at)RUV(dot)de> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Greenplum 6.x Support |
Date: | 2021-08-01 13:40:13 |
Message-ID: | babe3530b67448b3b12505d9cf493a37@RUV.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello pgadmin-hackers
i am working with Greenplum and pgadmin4 is my favorite tool every day since 2018.
Based on the GPDB5 support in Version 2.0 i did some (dirty) patches to get pgadmin4 useable with GPDB4. But that is history, we are on GPDB6 since 2020.
I hoped for an official support for GPDB6 but now i fear that the inofficial support will be dropped by housekeeping.
Please do not drop the gpdb-code.
I only need a few patches to work on GPDB6 with pgadmin4.
There are some uncritical Changes in Python-Code and additional SQL for GPDB6 in new directories.
Then there is a dirty patch because it may break something with other server_type than gpdb. This works for me but it is not a general solution.
It would be better to improve the way how sql_template_path ist set in "pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py"
and " pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py"
and "pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py"
Someone who is familiar with this framework will find a better solution.
Without this patch i cannot display dependencies or dependents:
depends/gpdb/#90424#/dependents.sql
and functions:
ERROR: column "proiswin" does not exist
LINE 5: proiswin, provolatile, proisstrict, prosecdef,
I am willing to work on Greenplum issues that may come up in the future. It will be easy if it can be done with a server specific SQL and the modules sql_temlplate_path supports server_type, but i need help if there ist something to do in Python-code.
Thanks
Harald Immerheiser
Attachment | Content-Type | Size |
---|---|---|
0001-Prepare-support-for-Greenplum-6.x.patch | application/octet-stream | 3.8 KB |
0002-Added-SQL-files-for-Greenplum-6.x.patch | application/octet-stream | 128.3 KB |
0003-Dirty-hack-to-fix-GPDB-6.x-support-for-functions.patch | application/octet-stream | 1.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2021-08-02 09:05:26 | Re: Greenplum 6.x Support |
Previous Message | Dave Page | 2021-07-29 15:31:37 | Re: McAfee Showing as Virus |