Re: Listen / Notify rewrite - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Listen / Notify rewrite
Date
Msg-id 14706.1257997386@sss.pgh.pa.us
Whole thread Raw
In response to Re: Listen / Notify rewrite  (Andrew Chernow <ac@esilo.com>)
Responses Re: Listen / Notify rewrite
List pgsql-hackers
Andrew Chernow <ac@esilo.com> writes:
>> I thought of a compromise: add the number of times a notification was 
>> generated (coalesced count+1) to the callback data. That would satisfy 
>> any backwards compatibility concerns and my use case too!

> If you are suggesting that the server poke data into the notifier's opaque 
> payload, I vote no.  Maybe the NOTIFY command can include a switch to enable 
> this behavior.  No syntax suggestions at this point.

I agree, we should not have the system modifying the payload string for
this.  And don't bother suggesting a third column in the result ---
we'd have to change the FE/BE protocol for that, and it's not going
to happen.

The existing precedent is that the system collapses identical
notifications without payloads.  So we could possibly get away with
saying that identical payload-less notifies are collapsed but those
with a payload are not.  That doesn't really seem to satisfy the
POLA though.  I think Joachim's definition is fine, and anyone who
needs delivery of distinct notifications can easily make his payload
strings unique to ensure it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Emmanuel Cecchet
Date:
Subject: Re: Patch committers
Next
From: Andrew Chernow
Date:
Subject: Re: Listen / Notify rewrite