Hackers,
I am in the process of fixing the oid2name contrib module. It needs a
lot of care and feeding. Hopefully for the next release we can move it
to src/bin/scripts so it can use the routines that are in common.c, and
some of the ugliness can go.
I think it will stay in contrib for 8.0 however, so it needs to be fixed
now. While I was playing with it, I noticed several shortcomings:
- it only works in the PUBLIC schema
- it only knows about tables and databases, except when running in "show systables" mode, and then it will show all
indexes,toast tables, etc
- it only displays relfilenode and tablename
- there's no way to query by relfilenode, only by Oid (note that the last two means the program is somewhat
inconsistent)
This last one IMHO makes the program somewhat useless, because what the
user normally wants to know is what table does a certain file on disk
belong to, and the Oid may not provide that.
I want to fix this, by providing switches to allow querying by filenode,
Oid and tablename; and to show not only filenode and name, but also
schema and tablespace.
Is this acceptable for this release? Other opinions?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"This is a foot just waiting to be shot" (Andrew Dunstan)