From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | ivan_14_32 <ivan_14_32(at)mail(dot)ru> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Notify rule |
Date: | 2011-02-22 17:49:25 |
Message-ID: | AANLkTikxV2dbiKKLrtKf5D+a0J+SirLj_+ct23Bi13nn@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Feb 22, 2011 at 1:03 AM, ivan_14_32 <ivan_14_32(at)mail(dot)ru> wrote:
> 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.
why use a rule here and not a trigger? triggers might be a bit more
verbose to right but explicit rules have and endless list of gotchas
and should be avoided unless you have a really good reason not to.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2011-02-22 18:03:40 | Re: Reordering a table |
Previous Message | Tom Lane | 2011-02-22 17:39:02 | Re: work_mem = 900MB but Sort Method: external merge Disk: 304008kB |