Re: fail-safe sql update triggers

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: fail-safe sql update triggers
Дата
Msg-id 4C80DAAB02000025000351AA@gw.wicourts.gov
обсуждение исходный текст
Ответ на fail-safe sql update triggers  (Michael Monnerie<michael.monnerie@is.it-management.at>)
Ответы Re: fail-safe sql update triggers  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Список pgsql-admin
Michael Monnerie<michael.monnerie@is.it-management.at> wrote:

> But that is error prone, because when the "filter" table is
> changed to have a new column, the UPDATE statement would not
> contain it. Is there a fail-proof shortcut?

You might draw inspiration for a C-based solution from Andrew
Dunstan's "minimal update" code.  A quick search turned up this, but
you might want to read the whole thread and look for possible later
versions of the code:

http://archives.postgresql.org/pgsql-hackers/2008-10/msg01111.php

-Kevin

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

Предыдущее
От: Michael Monnerie
Дата:
Сообщение: fail-safe sql update triggers
Следующее
От: "Rob Richardson"
Дата:
Сообщение: Re: fail-safe sql update triggers