Re: [Pypgsql-users] Re: postgresql notifications

[Billy G. A. <bil...@mu...>]

Gerhard H=E4ring wrote:

> [Cc-ed to pypgsql-users - I'd recommend to take this discussion over=20
> there]
>
> Witek wrote:
>
>> Gerhard H=E4ring wrote:
>>
>>>> I'm using pypgsql to connect to postgresql database (7.2, 7.3).
>>>> I recieve PgNotify object using notifies() method of connection=20
>>>> object, but it's fields values are random chars and wrong process=20
>>>> id. Is there someone, who put it to work?
>>>
>>>
>>> The pyPgSQL source distribution includes examples for notifications=20
>>> (examples/demo2a.py, examples/demo2b.py).
>>> Please report back if you still have problems.
>>
>>
>> They are not working under Linux or Windows. I tried examples from=20
>> gnumed project as well.
>
>
> They did certainly work for me last time I checked.
>
> Do you have different versions of the PostgreSQL client library and=20
> the server? If for example you use a 7.3 client and a 7.2 server there=20
> might be some problems ... Just a rough guess of me of course.
>
> -- Gerhard

It was working the last time I checked, but it's not working now :-(
I've update the CVS repository with a fixed pgnotify.c that will correct=20
the problem.  I am also attaching a patch file to correct the problem.

--=20
_________________________________________________________________________=
__
____       | Billy G. Allie    | Domain....: Bil...@mu...
|  /|      | 7436 Hartwell     | MSN.......: B_G...@em...
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |