On Sun, October 4, 2009 1:48 pm, Pavel Stehule wrote: > 2009/10/4 David Fetter <da...@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 <da...@fetter.org> http://fetter.org/ >> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter >> Skype: davidfetter    XMPP: david.fet...@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: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers