Search Postgresql Archives

pg_locks.relation question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

session one:

locks=# begin;
BEGIN
locks=# alter table test add column b text;
ALTER TABLE
locks=#

Session 2 querying pg_locks for the PID from above:

locks=# select locktype,relation::regclass,mode from pg_locks where pid = 2026 and locktype = 'relation';
 locktype | relation |        mode        
----------+----------+---------------------
 relation | test     | AccessExclusiveLock
 relation | 17728    | AccessExclusiveLock
 relation | 17726    | ShareLock
(3 rows)

What are these 17728 and 17726 OIDs? Nothing else is happening except these two sessions.

Thanks in advance
Daniel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux