pg_lock_status not documented

=?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= <martin.marques@gmail.com> writes:

I'm searching for information on pg_lock_status() function, but there
seams to be nothing in the docs. Maybe missing?

It's not documented because it's an internal function that you shouldn't
call directly. Look at the docs for the pg_locks view, which is the
public API.

regards, tom lane

Mart�n Marqu�s <martin.marques@gmail.com> writes:

I'm searching for information on pg_lock_status() function, but there
seams to be nothing in the docs. Maybe missing? Any hits, at least
what each column outputed is.

Have a look at the pg_locks view which wraps this function.

\d+ pg_locks

Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 305.321.1144

I know pg_locks, but I thought maybe pg_lock_status had some extra info.

Thanks anyway

2011/9/2 Tom Lane <tgl@sss.pgh.pa.us>:

=?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= <martin.marques@gmail.com> writes:

I'm searching for information on pg_lock_status() function, but there
seams to be nothing in the docs. Maybe missing?

It's not documented because it's an internal function that you shouldn't
call directly.  Look at the docs for the pg_locks view, which is the
public API.

                       regards, tom lane

--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador