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