[eric4smith]

I think if you're joining against wrong tables or columns, then you have bigger problems than if the values are BigInt or UUID's.

[sk5t]

"Don't ever be wrong" is one way to do it; on the other hand, sometimes we make mistakes anyway, especially in ad hoc queries, and not getting any results back at all helps to spot the problem quickly (more quickly than spending minutes befuddled by the nonempty resultset).

[eric4smith]

One thing that no one mentions so far is the extra space these ids consume.

Is the value of making that mistake strong enough that you use so much more data to store a UUID value??

[sk5t]

Well, I in fact did mention the "compactness" of integers at the start of this thread :)