Re: Materialized View Patch File - Mailing list pgadmin-hackers

From Neel Patel
Subject Re: Materialized View Patch File
Date
Msg-id CAMcbDBGTikst8kN0Pxe8ghqp3WmqWurpEwQwG0ET_rMMNopH0g@mail.gmail.com
Whole thread Raw
In response to Re: Materialized View Patch File  (Dave Page <dave.page@enterprisedb.com>)
List pgadmin-hackers
Thanks Dave.

Thanks,
Neel Patel


On Mon, Jul 8, 2013 at 6:04 PM, Dave Page <dave.page@enterprisedb.com> wrote:
Thanks, patch applied.

On Wed, Jul 3, 2013 at 8:44 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
> Hi Dave,
>
> Thanks for the comments.
>
> Find the attached patch with below fix.
>
> --- Incomplete comments removed and added new comments
> --- s/Closed/Materialized/
> --- Added column "relkind" in outer query and removed the SELECT from the
> loop.
> --- Combined the below statement.
>      "(collection->GetConnection()->BackendMinimumVersion(9, 3))"
>
> Please let me know for further comments.
>
> Thanks,
> Neel Patel
>
>
> On Tue, Jul 2, 2013 at 8:06 PM, Dave Page <dave.page@enterprisedb.com>
> wrote:
>>
>> Hi
>>
>> On Tue, Jul 2, 2013 at 3:25 PM, Thom Brown <thom@linux.com> wrote:
>> > On 29 May 2013 10:40, Neel Patel <neel.patel@enterprisedb.com> wrote:
>> >> Hi Dave,
>> >>
>> >> Please find the updated patch after fixing some of the issues and
>> >> comments
>> >> given by Ashesh.
>> >
>> > Just realised this reply has been in my draft folder for over a month...
>> >
>> >
>> > This comment appears to be incomplete:
>> >
>> > //While editing the view, if it is materialized view then only change
>>
>> Yeah, please fix that Neel. Not sure what you were trying to say.
>>
>> >
>> > The section of if... else if... else if... that begins with:
>> >
>> > if (name == wxT("autovacuum_vacuum_cost_delay"))
>> >
>> > should probably use:
>> >
>> > switch(name)
>> > {
>> >     case wxT("autovacuum_vacuum_cost_delay")
>> >
>> >     case ...
>> > }
>>
>> wxString's don't play nicely with switch(), if memory serves.
>>
>> > Given the amount of duplicate functionality this shares with tables,
>> > is there not a way there could be a common class they could both
>> > inherit from to reduce maintenance overhead?
>>
>> Probably not a great deal of benefit. In any case, it would certainly
>> require a lot of refactoring which is far more work than we have time
>> for.
>>
>> --
>> Dave Page
>> Chief Architect, Tools & Installers
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>
>



--
Dave Page
Chief Architect, Tools & Installers
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

pgadmin-hackers by date:

Previous
From: Ashesh Vashi
Date:
Subject: Re: PATCH: Handling too many notices from the debugging function
Next
From: Dave Page
Date:
Subject: pgAdmin III commit: Avoid the most serious side effects of the debugger