On Fri, Jun 29, 2012 at 3:29 AM, Richard Huxton <dev@xxxxxxxxxxxx> wrote: > On 29/06/12 09:01, adasko98 wrote: >> >> Hi >> In first sorry for my english :) I have got a problem with >> notify/listener. >> I do a function which returns a trigger. Everything is ok but when i want >> send in a second parameter a variable NOTIFY say: "syntax error" > > >> Notify demoApp, 'some text'; > > >> n_user :='sda'; >> Notify demoApp, n_user ;<----here is a problem > > > Looks like a limitation of the plpgsql parser, perhaps even counts as a > bug. > You can work around it with EXECUTE though, something like: > cmd := 'NOTIFY demoApp, ' || quote_literal(n_user); > EXECUTE cmd; > or just > EXECUTE 'NOTIFY demoApp, ' || quote_literal(n_user); also see pg_notify() function. Yes i'm looking for that. But i connect c# application with postgres and pg_notify() don't work with my notify event. Anyway thanks for help -- View this message in context: http://postgresql.1045698.n5.nabble.com/Notiffy-problem-tp5714744p5714782.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
