Streamsoft - Mirek Szajowski <m.szajowski@xxxxxxxxxxxxx> writes: > Why I can't execute 'select for update' but I can update? In recent PG versions, the lock held due to having inserted an FK dependent row effectively only locks the key fields of the parent row. UPDATE can tell whether you're trying to change the row's key fields, and it will proceed if you aren't. SELECT FOR UPDATE has to lock the whole row (since it must assume you might be intending to change any fields of the row); so it blocks until the FK lock goes away. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
