Re: updated lock listing patch - Mailing list pgsql-patches

I am confused by pg_locks_result.  I see it in \dS, but it doesn't
appear to display anything useful, based on the view definition.  Is
this the cleanup you were talking about, Neil?

---------------------------------------------------------------------------

    test=> \d+ pg_locks
               View "pg_catalog.pg_locks"
       Column   |  Type   | Modifiers | Description
    ------------+---------+-----------+-------------
     relation   | oid     |           |
     database   | oid     |           |
     backendpid | integer |           |
     mode       | text    |           |
     isgranted  | boolean |           |
    View definition: SELECT pg_lock_status.relation,
    pg_lock_status."database", pg_lock_status.backendpid,
    pg_lock_status."mode", pg_lock_status.isgranted FROM pg_lock_status();

    test=> \d+ pg_locks_result
           View "pg_catalog.pg_locks_result"
       Column   |  Type   | Modifiers | Description
    ------------+---------+-----------+-------------
     relation   | oid     |           |
     database   | oid     |           |
     backendpid | integer |           |
     mode       | text    |           |
     isgranted  | boolean |           |
    View definition: SELECT 0::oid AS relation, 0::oid AS "database", 0 AS
    backendpid, ''::text AS "mode", NULL::boolean AS isgranted;

---------------------------------------------------------------------------

Bruce Momjian wrote:
>
> Patch applied.  Thanks.
>
> ---------------------------------------------------------------------------
>
>
> Neil Conway wrote:
> > Neil Conway <nconway@klamath.dyndns.org> writes:
> > > This patch is an updated version of the lock listing patch.
> >
> > Woops, that patch was half-baked -- the changes to the regression
> > tests were only partially included (thanks to Alvaro Herrera for
> > pointing that out). I've attached an updated patch.
> >
> > Cheers,
> >
> > Neil
> >
> > --
> > Neil Conway <neilconway@rogers.com>
> > PGP Key ID: DB3C29FC
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073