Thread: pg_lock_status not documented

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.

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

=?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