BUG #7511: 9.2: pg_stat_activity.procpid renamed unnecessarily

From: i(at)avdd(dot)co
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7511: 9.2: pg_stat_activity.procpid renamed unnecessarily
Date: 2012-08-30 04:34:18
Message-ID: E1T6wSQ-0005kN-LD@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7511
Logged by: Adrian Dries
Email address: i(at)avdd(dot)co
PostgreSQL version: Unsupported/Unknown
Operating system: any
Description:

In trying 9.2 I find pg_stat_activity.procpid has been renamed to pid.

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4f42b546fd87a80be30c53a0f2c897acb826ad52

It seems the premise of this is

If we're going to rename current_query to query--what Scott's patch does
here--that will force all code using pg_stat_activity to be rewritten. This
seems like the perfect time to also change "procpid" to "pid", finally blow
away that wart.

A premise that is untrue: changing a subset of columns on a relation does
not force "all code" using that relation to be rewritten:

SELECT procpid FROM pg_stat_activity WHERE procpid <> pg_backend_pid()

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2012-08-30 08:49:41 Re: [BUGS] PostGreSQL pgdac - C++ Builder 2007
Previous Message Tom Lane 2012-08-30 04:10:06 Re: BUG #7510: Very bad costing estimation on gin vs gist with FTS