Re: Rules: A Modest Proposal - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: Rules: A Modest Proposal
Date
Msg-id 721eb15e3b43577ecdcd538d6a2b2ef6.squirrel@webmail.lerctr.org
Whole thread Raw
In response to Re: Rules: A Modest Proposal  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Sun, October 4, 2009 1:48 pm, Pavel Stehule wrote:
> 2009/10/4 David Fetter <david@fetter.org>:
>> Folks,
>>
>> At the moment, user-accessible RULEs have, as far as I know, just two
>> sane uses:
>>
>> * Writing to VIEWs
>> * Routing writes to partitions
>
> somebody use it as instead triggers. And I am sure, so there are
> people, who use it for writable views.

We have such a rule (instead of a trigger) in our SaaS app.  I'm lobbying
to remove it, and make it a real trigger, but that hasn't happened yet.

so there are folks out there.

>
> regards
> Pavel Stehule
>
>>
>> And the second is pretty thin, given the performance issues for
>> numbers of partitions over 2.
>>
>> What say we see about addressing those problems separately, and
>> removing user-accessible RULEs entirely?
>>
>> There are already patches to deal with the first, at least for the
>> kinds of VIEWs where this can be deduced automatically, and people are
>> starting to take on the second.
>>
>> The one remaining (as in nobody's really addressed it with code) issue
>> would be triggers on VIEWs.  As other systems have done it, it's
>> clearly not essentially impossible.  What would be needed?
>>
>> Cheers,
>> David.
>> --
>> David Fetter <david@fetter.org> http://fetter.org/
>> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
>> Skype: davidfetter      XMPP: david.fetter@gmail.com
>>
>> Remember to vote!
>> Consider donating to Postgres: http://www.postgresql.org/about/donate
>>
>> --
>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893




pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Rules: A Modest Proposal
Next
From: Itagaki Takahiro
Date:
Subject: Re: Triggers on columns