On Sat, Jan 22, 2005 at 05:21:32PM -0600, Jim C. Nasby wrote: > Out of curiosity, what's the relation between the tables in pg_catalog > and the 'actual system objects'? I ass-u-me'd that these tables were the > backing store for the real information, but maybe that's not the case.
They are. > I think these views are also very useful in certain programming > situations, in which also having the OIDs might be very useful. Another > option would be to have functions that given a array of names would > return a array of OIDs. So why not have both in the view? It's not like you are storing duplicated data anyway. -- Alvaro Herrera (<[EMAIL PROTECTED]>) "Ellos andaban todos desnudos como su madre los parió, y también las mujeres, aunque no vi más que una, harto moza, y todos los que yo vi eran todos mancebos, que ninguno vi de edad de más de XXX años" (Cristóbal Colón) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend