Hi, I have objects in my database, and they have an object id generated with a sequence. Then I have object versions. The ids of object versions need to be unique only within one object id. But for simplicity they're generated with a sequence, too.
Now I want to reference an object version. I can use just the object version id, because it "happens" to be globally unique. Conceptually though, I should use the object's id and its version's id. Now redundancy is Not Goodâ, so I wonder which way is the Right Oneâ. I understand that both ways work and that the variant with just the object id is probably both faster and smaller. I'd be thankful for enlightenment :) -- Markus Bertheau <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html