adasko98 wrote:
> Hi thanks for help. Now i know why pg_notify() does not works for
> me. I'm named listener in c# code 'Demo' and this is a problem. In
> name can't be a capital letter because postges change this name to
> small letter i think. So if someone want use pg_notify use only
> small
Hi thanks for help. Now i know why pg_notify() does not works for me. I'm
named listener in c# code 'Demo' and this is a problem. In name can't be a
capital letter because postges change this name to small letter i think. So
if someone want use pg_notify use only small letter like this
"pg_notify('
Merlin Moncure writes:
> On Fri, Jun 29, 2012 at 8:58 AM, adasko98 wrote:
Notify demoApp, n_user ;>> 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
On Fri, Jun 29, 2012 at 8:58 AM, adasko98 wrote:
>
> On Fri, Jun 29, 2012 at 3:29 AM, Richard Huxton 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
On Fri, Jun 29, 2012 at 3:29 AM, Richard Huxton 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 varia
On Fri, Jun 29, 2012 at 3:29 AM, Richard Huxton 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 variab
Thanks for your answer. Now it works.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Notiffy-problem-tp5714744p5714750.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
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';
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"
This is works example with no variable:
CREATE OR REPLACE FUNCTION notify_demo
