Bruce Momjian <[EMAIL PROTECTED]> writes: > In this way, no one ever has the rename file open while we are holding > the locks, and we can loop without holding an exclusive lock on > pg_shadow, and file writes remain in order.
You're doing this where exactly, and are certain that you are holding no locks why exactly? And if you aren't holding a lock, what prevents concurrency bugs? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match