Re: [GENERAL] Is it possible that session lock is not released

2013-12-11 Thread Tom Lane
T writes: > Now transaction goes to default state, then this backend is killed or some > FATAL error happens, > AbortOutOfAnyTransaction() in ShutdownPostgres() will do nothing since > transaction is in default > state, and session lock on heaprelid is still held after ShutdownPostgres(), > so

[GENERAL] Is it possible that session lock is not released

2013-12-11 Thread T
Hi, I just found that ShutdownPostgres() only releases USER_LOCKMETHOD locks, so why not release DEFAULT_LOCKMETHOD locks? Check if this is possible: We are doing a CREATE INDEX CONCURRENTLY, and codes runs to LockRelationIdForSession(&heaprelid, ShareUpdateExclusiveLock); PopAct