PostgreSQL alerts to C++ application

Question

My C++ application has to receive alerts from the PostgreSQL database, as soon as any data is modified in tables. Can you please advice to implement this in best possible way.

Please note that alert information would also need to have the information of the data that has been changed.

Thanks, Gtk

user330315 · Accepted Answer · 2010-10-09 19:20:49Z

1

Write a regular pl/pgSQL trigger that sends a NOTIFY when something changes

In your program you can use LISTEN to receive the messages.

The only drawback is, that you need to poll from within your application in regular intervals in order to receive the messages

In 8.x the message sent around could not carry any payload. In 9.0 you can send additional information with the message.

answered Oct 9, 2010 at 19:20

user330315

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

1 Comment

Chris Travers Over a year ago

I would recommend not relying on the payload though. Anyone can send a notification with arbitrary payload. The data really should come from the table.

Peter G. · Accepted Answer · 2010-10-09 18:51:08Z

0

I would write C triggers to receive change information.

answered Oct 9, 2010 at 18:51

Peter G.

15.2k7 gold badges60 silver badges76 bronze badges

Collectives™ on Stack Overflow

PostgreSQL alerts to C++ application

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related