Merlin Moncure <mmonc...@gmail.com> writes:
> On Fri, Jun 29, 2012 at 8:58 AM, adasko98 <adasko...@gmail.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
