Merlin Moncure <mmoncure@xxxxxxxxx> writes: > On Fri, Jun 29, 2012 at 8:58 AM, adasko98 <adasko.86@xxxxxxxxx> wrote: >>>> Notify demoApp, n_user ;<----here is a problem >>> Looks like a limitation of the plpgsql parser, perhaps even counts as a >>> bug. It is not a bug, but a documented limitation of the NOTIFY command: the payload has to be a simple string literal. (The technical reason for that is that NOTIFY isn't a plannable statement, but a utility command, and utility commands generally don't evaluate expressions. In principle we could fix that, but in practice it's not going to change, because the pg_notify() function serves just fine for every case where you want a non-constant payload.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
