[Pljava-dev] Question regarding triggers and data visibility

[Burtenshaw, John J.]

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://pgfoundry.org/pipermail/pljava-dev/attachments/20051111/7c56f5dd/attachment.html