Conditional NOTIFY is not implemented
От | tomas@fabula.de |
---|---|
Тема | Conditional NOTIFY is not implemented |
Дата | |
Msg-id | 20010906151526.B23923@www обсуждение исходный текст |
Ответы |
Re: Conditional NOTIFY is not implemented
|
Список | pgsql-bugs |
Hi, Upgrading from 7.0.2 to 7.1.3 (great job, btw!), brought us some problems. Watch the following: | versuch=# create table chkntfy ( | versuch(# NUMMER integer default 0 not null, | versuch(# TEXT varchar(255) default '?' not null | versuch(# ); | CREATE | versuch=# | versuch=# CREATE RULE ru_u_chkntfy AS ON UPDATE TO chkntfy DO NOTIFY CHKNTFY; | CREATE | versuch=# insert into chkntfy (nummer,text) values ('1','eins'); | INSERT 110522 1 | versuch=# update chkntfy set nummer=10 where nummer = 1; | ERROR: Conditional NOTIFY is not implemented | versuch=# Matthew Copeland noted the same in pgsql-admin and was told to use triggers instead of rules. Well, it's a little nuisance, since we don't have statement triggers (you'd get a notify for each row modified, which in our case can be a killer.) Somehow the notify seems to take up the `where' qualifier of the query triggering the rule (you don't get the error message if you use an unqualified query). Is this considered a bug? Is a fix in sight? Regards -- tomas
В списке pgsql-bugs по дате отправления: