On Fri, Feb 11, 2005 at 04:26:04PM -0500, Alex Turner wrote: > > What does the column 'relation' in pg_locks key to (Is there any docs > on the website for this?)
See the "System Catalogs" chapter in the documentation (substitute your version of PostgreSQL in the link): http://www.postgresql.org/docs/8.0/static/catalogs.html "relation" refers to an oid in pg_class. An easy way to convert it to a relation name is to cast it to regclass: SELECT relation::regclass, * FROM pg_locks; -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(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
