| 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: | Whole Thread | Raw Message | Download mbox | Resend email | 
| 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.
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()
| 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 |