Notify rule

From: ivan_14_32 <ivan_14_32(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Notify rule
Date: 2011-02-22 07:03:36
Message-ID: 4D635FC8.20304@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!
I trying to create rule for update notifing:

CREATE OR REPLACE RULE "ttt_NotifyU" AS
ON UPDATE TO "ttt" DO
NOTIFY "ttt", '88';
this work.

But this
CREATE OR REPLACE RULE "ttt_NotifyU" AS
ON UPDATE TO "ttt" DO
NOTIFY "ttt", NEW."id";
don't (syntax error),
NOTIFY "ttt", CAST(NEW."id" as text)
too.

Q: How can I send tuple id (integer primary key) via notify using Rule?
Target is erasing deprecated tuples from application's cache.

<mailto:ivan_14_32(at)mail(dot)ru>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Itnal, Prakash (NSN - IN/Bangalore) 2011-02-22 07:26:23 Restart Issue in Cluster environment
Previous Message ChronicDB Community Team 2011-02-22 00:52:53 Re: Schema version control