Re: lock listing - Mailing list pgsql-patches

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: lock listing
Date
Msg-id 20020723224718.GA11484@klamath.dyndns.org
Whole thread Raw
In response to Re: lock listing  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: lock listing  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: lock listing  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
On Tue, Jul 23, 2002 at 05:52:39PM -0400, Bruce Momjian wrote:
> I agree with Peter that it is better to rename it pg_lock*.  The show
> isn't needed and it makes it look more like our other system info
> tables.

Well, it's not a system info table -- it's a built-in function, and I'm
not aware of any naming conventions for those. Personally, I find it a
bit confusing to do:

    SELECT * FROM pg_tables;
    SELECT * FROM pg_class;
    /* ... */
    SELECT * FROM pg_locks();

However, I'm not really worried about the name, so I've changed it
to pg_locks() -- a revised patch is attached.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Table Function API doc patch
Next
From: Bruce Momjian
Date:
Subject: Re: Fk fix for noaction update/delete