Hannu Krosing <[EMAIL PROTECTED]> writes: > Does ALTER TABLE SET TABLESPACE lock the table
It had better ... see nearby discussion about relaxing locking for TRUNCATE. Exactly the same problem that at commit we'd be cutting the ground out from under any concurrent query. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match