Re: PATCH: Schema/Catalog Node [pgAdmin4]

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
Subject: Re: PATCH: Schema/Catalog Node [pgAdmin4]
Date: 2016-03-08 14:06:59
Message-ID: CAG7mmoweuCSmnoKtVjAg2ujYozN-OTOtK5w6eLTKsmf1HCNA9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Dave,

On Tue, Mar 8, 2016 at 12:20 AM, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com
> wrote:

> Hi Dave,
>
>
> On Thu, Mar 3, 2016 at 8:27 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> Hi
>>
>> On Sun, Feb 28, 2016 at 6:49 AM, Ashesh Vashi <
>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> Hi Dave,
>>>
>>> As discussed, I have worked on this patch to improve some code level
>>> changes.
>>> (because - Murtuza was not available due to some other engagement.)
>>>
>>> Can you please review it, and share your feedback?
>>>
>>
>> I think it's mostly there. I've attached an updated patch where I've
>> fixed a few minor issues as I read through the code. The following (likely
>> simple) issues need to be fixed:
>>
>> - Dropping a schema fails with an error message of "
>> schema/pg/9.2_plus/sql/get_name.sql".
>>
> Done.
>
>>
>> - Creating a schema appears to fail with "'data' is undefined", however
>> the schema is created, it's just that the dialogue doesn't close and the
>> new schema isn't added to the tree.
>>
> Done.
>
>>
>> - There is some discrepancy between default privileges as displayed on
>> the properties summary, the edit dialogue, and the RE-SQL. As you can see
>> in the screenshot, the SQL just GRANTS ALL, and the properties panel
>> doesn't show anything.
>>
> Yes - there were some typos in the schema/catalog node implementation,
> which I have resolved now.
>
> Please find the updated patch.
>
One more updated patch:
Some of the catalogs will not have all the schema child objects.
Hence - they will need to check certain thing likes they're not being
loading in the catalog with such property (i.e. pg_catalog).
To ease the work, I have introduced a class name SchemaChildModule, which
does that job for us.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com/>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

>
> --
> Thanks & Regards,
> Ashesh Vashi
>
>
>> Thanks.
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>

Attachment Content-Type Size
schema_catalog_node_v10.patch application/octet-stream 194.4 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Ashesh Vashi 2016-03-08 14:18:26 Re: PATCH: Schema/Catalog Node [pgAdmin4]
Previous Message Murtuza Zabuawala 2016-03-08 14:02:11 PATCH: Updated acl parsing on tablespace node [pgAdmin4]