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

Responses

• Re: Conditional NOTIFY is not implemented at 2001-09-06 19:16:26 from Tom Lane

pgsql-hackers by date

Next:	From: David Wheeler	Date: 2001-09-06 13:22:22
	Subject: Re: Bug in createlang?
Previous:	From: Doug McNaught	Date: 2001-09-06 12:39:27
	Subject: Re: Is there a problem running vacuum in the middle of a transaction?

pgsql-bugs by date

Next:	From: pgsql-bugs	Date: 2001-09-06 14:29:00
	Subject: Bug #439: no inherits constraints
Previous:	From: Michał Pasternak	Date: 2001-09-06 10:27:48
	Subject: Re: ILIKE + OR fault - propably a memory leak