On Thu, Jun 9, 2011 at 11:54 AM, Bruce Momjian <br...@momjian.us> wrote: > Can someone explain why pg_stat_activity has a column named procpid and > not simply pid? 'pid' is that pg_locks uses, and 'procpid' is redundant > (proc-process-id). A mistake?
Well, we refer to the slots that backends use as "procs" (really PGPROC), so I'm guessing that this was intended to mean "the pid associated with the proc". It might not be the greatest name but I can't see changing it now. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers