aren(at)arencambre(dot)com writes:
> (Note that this issue is described fully at
> http://stackoverflow.com/questions/9713537/postgres-left-join-is-creating-new-data.
> A few knowledgeable people have weighed in, and there is no solution
> identified.)
This might be a bug, but you've not provided sufficient information for
someone else to reproduce the problem. What would be good is a SQL
script that reproduces the error from a standing start (empty database).
regards, tom lane