Greg Stark <[EMAIL PROTECTED]> writes: > Oh I missed the fact that you were talking about after a reboot. So the > algorithm I described would produce exactly the same sequence of ids after any > reboot given the same sequence of creation and deletions. Even if there's a > different sequence as long as the n'th creation is for the m'th array slot it > would get the same id. So collisions would be very common.
This seems to square with Ed's complaint that he frequently sees a collision after a reboot. I've just committed some code that makes a more extensive check as to whether a pre-existing segment actually has any relevance to our data directory; should fix the problem. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html