Is it wrong to assign current_timestamp to a timestamp field because current_timestamp is "with time zone"? If so, that's amazing since I thought under the hood its all UTC. I can't see that mentioned in the documentation that using current_timestamp can be so dangerously wrong when assigned to a timestamp.
Using timestamp without time zone is really the issue here. There is even a “don’t do this” entry for it.
