ERROR: Conditional NOTIFY is not implemented

Поиск
Список
Период
Сортировка
От matthew.copeland@honeywell.com
Тема ERROR: Conditional NOTIFY is not implemented
Дата
Msg-id Pine.LNX.4.21.0108212103460.30010-100000@fisb.gaa.aro.allied.com
обсуждение исходный текст
Ответ на RE: Creating Users  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: ERROR: Conditional NOTIFY is not implemented
Список pgsql-admin
I have a set of rules that worked in 7.0.3 for async notification.  Those
same set of rules don't seem to be working under 7.1.2.  The rules look
like this.

CREATE RULE CONFIG_CHNG AS ON INSERT TO gs_config DO (NOTIFY CONFIG_CHANGE);
CREATE RULE CONFIG_CHNG AS ON UPDATE TO gs_config DO (NOTIFY CONFIG_CHANGE);
CREATE RULE CONFIG_CHNG AS ON DELETE TO gs_config DO (NOTIFY CONFIG_CHANGE);

Here is a look at what my session looks like.

bash# psql config
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

config=# insert into gs_config values ('Life','42');
INSERT 18842 1
config=# update gs_config set config_value='0' where config_name='Life';
ERROR:  Conditional NOTIFY is not implemented
config=# delete from gs_config where config_name='Life';
ERROR:  Conditional NOTIFY is not implemented
config=# \q


Obviously, this isn't what I desired to have happen.  :)  Anyone have any
ideas on either a way that I can get around this little feature?  I really
really need the async notification stuff.

Thanks,
Matthew M. Copeland



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

Предыдущее
От: Joshua Franklin
Дата:
Сообщение: ...
Следующее
От: "Stefan Scherf"
Дата:
Сообщение: readonly acces to a db