Re: lock listing

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