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/