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
