I'm posting this because it took me 3 days to finally figure out what was going on. I'm using PDI 4.2.1. The PostgreSQL Bulk Loader was recently enhanced to handle empty streams gracefully, and that's great. However, what I found is that if I have TRUNCATE specified for the "Load Action," and the stream is empty, then the table will NOT be truncated.

I'm not saying that this is "wrong," but I was troubleshooting a problem caused by this behavior, and it took a while.

Hopefully the next person to be confused by this will google for an explanation, run into this message, and happily go on his or her way.