From: | rwelty at ltionline(dot)com (Welty, Richard) |
---|---|
To: | |
Subject: | [Pljava-dev] null pointer exception in pl/java jdbc driver |
Date: | 2012-05-25 12:40:36 |
Message-ID: | C35FDD5FDF7E584991A6AAF8F1A8425F0226AD57@ltischx01.lti.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
the issue has been identified, this summary is to help anyone who comes along with a similar issue
in the future.
the root cause is there was a trigger being fired which should not have been. instead of triggering
after insert, it was triggering after insert or delete, and then attempting to operate on rows which
the retryPush function had just deleted from the table.
i only got an idea of what was going on after i ran the function from psql with these two debug
settings as requested by Johann:
SET log_min_messages = debug;
SET client_min_messages = debug;
until i set these and reviewed the output, i had no idea that the unwanted trigger was where
the error actually originated.
richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120525/0f655e0d/attachment.html>
From | Date | Subject | |
---|---|---|---|
Next Message | binoyaf | 2012-05-25 15:36:16 | [Pljava-dev] Snapshot released and Windows binaries of 1.4.3 |
Previous Message | Johann 'Myrkraverk' Oskarsson | 2012-05-25 10:56:31 | [Pljava-dev] Snapshot released and Windows binaries of 1.4.3 |