[Pljava-dev] Question regarding triggers and data visibility

I have created a trigger that notifies a daemon process (via the java
RMI mechanism) that a new record has been inserted into a table. The
problem I am having is that the record is not visible to the daemon
process after it performs a 'select' on the table in question. Further
investigation shows that the new record was successfully inserted into
the table. The strange thing is that if I do a table lock (i.e. 'lock
table') in the trigger method before notifying the daemon the data
becomes visible to the daemon!! I don't like using the lock as I have
had issues with the lock causing random problems. Any ideas as to how I
can make the new data visible?

Regards,

John Burtenshaw

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20051111/7c56f5dd/attachment.html>