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

From Pavel Stehule
Subject Re: Rules: A Modest Proposal
Date
Msg-id 162867790910041148u371fc36by3b5ab3e9de8f2374@mail.gmail.com
Whole thread Raw
In response to Rules: A Modest Proposal  (David Fetter <david@fetter.org>)
Responses Re: Rules: A Modest Proposal
Re: Rules: A Modest Proposal
List pgsql-hackers
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.

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
>


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Rules: A Modest Proposal
Next
From: Josh Berkus
Date:
Subject: Re: [PATCH] DefaultACLs