Hi,
In one of our project we are supposed to send the notifications
regarding any row modifications in a perticular table to the external
application which will be implementing the listen event for the same.
We are using the postgress version 8.0.3.
we have observed that pgNotify
Hi Richard Huxton,
Thank you for your kind response.
Is there not any other way other than record the pkey in a
"process_these" table and have the application check there.We want
to minimise the database transactions to improve the DB performance.
Can we send the
Yes, our application is supposed to know *immediately* that a change in
the database has occurred since, based on this modified data it is doing
lot of other operations and also, the db transactions are heavy(expected
to be arround 300 tps(transactions per sec)).
I agree that this can be done usi
