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 по дате отправления: