Re: dump/restore with a hidden dependency?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: dump/restore with a hidden dependency?
Дата
Msg-id 1407448763.87414.YahooMailNeo@web122302.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Re: dump/restore with a hidden dependency?  (Chris Curvey <ccurvey@zuckergoldberg.com>)
Список pgsql-general
Дерево обсуждения 
Chris Curvey <ccurvey@zuckergoldberg.com> wrote:

> Perhaps a pair of triggers?  An insert-or-update trigger on foo, and a
> delete-or-update trigger on bar?

Using a foreign key constraint is best if that can do the right
thing.  If that doesn't work, triggers like you describe are
probably the best option, but you need to cover race conditions.
See this recent post for suggestions:

http://www.postgresql.org/message-id/1406836331.34944.YahooMailNeo@web122303.mail.ne1.yahoo.com

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Feature proposal and discussion: full-fledged column/function equivalence
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: The dangers of streaming across versions of glibc: A cautionary tale