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. 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