Best mechanism for change notification

Поиск
Список
Период
Сортировка
От jason_donmoyer@chiinc.com
Тема Best mechanism for change notification
Дата
Msg-id 001601c1c547$bc035750$451e6acf@CHIINC.COM
обсуждение исходный текст
Список pgsql-general

Hello all,

I'm interested in writing a C++ client for postgres which needs the ability to receive notification any time a value in the database, which the client deems important, changes (this can theoretically be any value in any column of the database). The conditions for this notification may change frequently over the course of the programs execution. What mechanisms exist in postgres to do this (I've briefly looked at triggers and Listen/Notify, just want to make sure I'm not missing something)? Which method is the most efficient, considering the constant need to update the trigger condition (or is it best to delete the old trigger and create a new one each time)?

Thanks for your assistance,

Jason Donmoyer

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

Предыдущее
От: Joseph Maxwell
Дата:
Сообщение: Field Constraints
Следующее
От: Dave Page
Дата:
Сообщение: Re: [ODBC] ODBC from win2k to postgres on Linux HELL