Hi, we found that
operations affecting triggers require exclisive lock on the related tables. We got FE=>Sync hang up problem and looked exactly like you described here. It should not be a network issue. It can be reproduced on both windows and linux platforms. However, our script was dropping and (re)creating triggers and not a batch insert that you reported here earlier. The solution was to *
close the current connection to postgres * establish a new one and run the script to modify the triggers * at the end
commit and close the connection * establsih a new connection to continue the work. I post our solution here because this is the most recent thread on this topic which I've found. I hope this can help others with this magic connection hang. Cheers, L
View this message in context:
Re: JDBC executeBatch() hangs without error Sent from the
PostgreSQL - jdbc mailing list archive at Nabble.com.