How to make PostgreSQL trigger and C# Windows Service work together?

Question

I want to write a windows service in C# that will wait for a change in the particular table in PostgreSQL database and then operate based on the data from the last inserted row. As far as I know (I'm new to PostgreSQL) I can use triggers to execute a function in structural code - but how to make it pass the data to my service?

Thanks in advance for any suggestions.

Magnus Hagander · Accepted Answer · 2010-01-27 18:08:24Z

1

Look at asynchronous notifications - http://www.postgresql.org/docs/8.4/static/sql-notify.html. Fire off a notification with NOTIFY from inside the trigger, have the service do LISTEN on it's connection and act upon the notification.

answered Jan 27, 2010 at 18:08

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kyrisu Over a year ago

This is great - exactly what I needed. It's also easy cause Npgsql (.net data provider for postgresql) supports it :)

Collectives™ on Stack Overflow

How to make PostgreSQL trigger and C# Windows Service work together?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related