On Tue, Feb 9, 2016 at 12:15 AM, Merlin Moncure <mmonc...@gmail.com> wrote:
> I wonder if the third argument > should be a boolean however. If we make it 'text, 'send mode', > instead, we could leave some room for more specialization of the > queuing behavior. > > For example, we've had a couple of requests over the years to have an > 'immediate' mode which dumps the notification immediately to the > client without waiting for tx commit. This may or may not be a good > idea, but if it was ultimately proved to be, it could be introduced as > an alternate mode without adding an extra function. But then it becomes disputable if SQL syntax change makes sense. ---we had this, NOTIFY channel [ , payload ] ---and in this patch we have this NOTIFY [ ALL | DISTINCT ] channel [ , payload ] --- but maybe we should have this? NOTIFY channel [ , payload [ , mode ] ] I'm not sure which direction is better with non-standard SQL additions. Recycling keywords or adding more commas? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers