PostgreSQL notify

4 posts, 0 answers
  1. Maciej
    Maciej avatar
    7 posts
    Member since:
    Feb 2012

    Posted 28 Jul 2012 Link to this post

    Hello,

    I'm using OpenAccess with postgresql database. In database I've triggers to send notify when data has been changed by my server side application. Please tell me how I can listen to this notification in my windows form application. Npgsql have dedicated event to catch notifies from server, but I don't know, how I can make this with OpenAccess. I need real-time data monitoring.

    Regards,
    Maciek
  2. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 30 Jul 2012 Link to this post

    Hi Maciej,

    Thank you for your question but unfortunately Telerik OpenAccess ORM does not support this PostgreSql feature.

    Feel free to ask if you have any other question.

    Greetings,
    Ralph
    the Telerik team
    OpenAccess ORM Q2'12 Now Available! Get your hands on all the new stuff.
  3. DevCraft banner
  4. Maciej
    Maciej avatar
    7 posts
    Member since:
    Feb 2012

    Posted 11 Aug 2012 Link to this post

    Hi Ralph,

    Thank you for the replay.
    Maybe can you provide me other solution than postgre trigger to trace data changes in my database in real-time?

    Regards,
    Maciek
  5. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 13 Aug 2012 Link to this post

    Hello Maciek,

    I guess the best option you have is to open another ADO connection in parallel to the connections OpenAccess uses and add your event notifications there. Because this is a Postgres specific feature we have no built-in support for this yet. This would catch all modifications in the database, including those made by other tools to the same data.
    If you just need the modifications made by the local OpenAccess application, you should have a look into the IInstanceCallback interface and the IContextEvents interface.

    Regards,
    Thomas
    the Telerik team
    Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Back to Top