Neil Conway wrote:
> 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.
We have pg_stat_activity. Seems pg_locks should behave the same,
without the (). Let it show up in \dS. Do you need assistance with
this? I know FRS is neat, but logically it seems it should appear as a
table like that statistics stuff.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026