Skip site navigation (1) Skip section navigation (2)

Re: Ticket 256: add INSTEAD OF support for triggers

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-hackers(at)postgresql(dot)org, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Subject: Re: Ticket 256: add INSTEAD OF support for triggers
Date: 2010-10-24 07:18:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
[Ashesh, if you haven't aready, I suggest reviewing this thread. It
may shed some light on that Rule weirdness on Solaris]

On Sat, Oct 23, 2010 at 11:03 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
>> pgView derives from pgSchemaObject
> Actually, pgView derives from pgRuleObject, which is already weird by
> itself but makes the whole thing even more weird.

Oh, I misread that. pgView*Factory* derives from pgSchemaObj*Factory*.
Which seems bizarre.

>> pgColumn derives from pgTableObject
> Seems logical.
>> and:
>> pgRule derives from pgRuleObject
>> pgRuleObject derives from pgSchemaObject
> Which just doesn't make sense. I would really like to know the reason of
> all this.

I think the point is, that pgRule can't be a descendent of a table or
a view (in the inheritance hierarchy), because it is a descendent of
both (logically).

>> My guess is to do this properly you'll probably have to create a
>> similar pgTriggerObject class (or make pgRuleObject into a more
>> generic pgRelationObject), and then add properties to represent the
>> table/view directly to pgTrigger and re-parent it appropriately.
> Will look into this.
> Thanks for your remarks. I hope to come up with something. We'll
> probably need someone more knowledgable than me with C++.

I don't think it needs "more C++ knowledge", just some patience to
untangle things. Do you know of any tools that can automatically
visually display the object model and members? I'm sure there used to
be something in Visual Studio, but I can't find it atm.

Dave Page
Twitter: @pgsnake

EnterpriseDB UK:
The Enterprise PostgreSQL Company

In response to


pgadmin-hackers by date

Next:From: Dave PageDate: 2010-10-24 08:06:40
Subject: pgAdmin III commit: Updated supported versions for 1.14. Now that weha
Previous:From: pgAdmin TracDate: 2010-10-24 02:13:01
Subject: [pgAdmin III] #268: Mousewheel support on Explain, Messages, History

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group