Re: [DOCS] Partition: use triggers instead of rules

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: [DOCS] Partition: use triggers instead of rules
Дата
Msg-id 20071129005334.GN24146@fetter.org
обсуждение исходный текст
Ответ на Re: [DOCS] Partition: use triggers instead of rules  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [DOCS] Partition: use triggers instead of rules  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-patches
On Wed, Nov 28, 2007 at 05:17:38PM -0500, Tom Lane wrote:
> David Fetter <david@fetter.org> writes:
> > On Wed, Nov 28, 2007 at 03:53:04PM -0500, Tom Lane wrote:
> >> Entirely removing the example of how to do it with rules doesn't
> >> seem like a good idea.
>
> > It does to me.  I haven't found a case yet where rules worked even
> > as well as triggers.
>
> I don't have a problem with emphasizing triggers as the preferred
> solution, but we should keep the older example, if only because
> people are going to see DB schemas that use that approach, and they
> won't understand what's going on (or realize they could convert) if
> they've not seen an example.

Greg Sabino Mullane managed to contrive an example where RULEs might
conceivably be the least-bad way to do this, that being a machine
where no PLs may be installed.

Telling people how to do this is not *quite* as bad as describing how
to do EAV, but it's pretty close.

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

В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: proposed patch for function parameters name refs
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [DOCS] Partition: use triggers instead of rules