Please submit any improvements you can. It certainly needs attention! I think it is inconsistent in using oid for lookup. It was originally written before relfilenode existed (hence the name _oid_2name, while it should be relfilenode to name or something. Maybe when we move it to scripts we can rename it.
--------------------------------------------------------------------------- Alvaro Herrera wrote: > 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) > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
