Re: [HACKERS] Re: [PATCHES] COMMENT ON patch - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Re: [PATCHES] COMMENT ON patch
Date
Msg-id 199910260504.BAA21027@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: [PATCHES] COMMENT ON patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Peter Eisentraut <e99re41@DoCS.UU.SE> writes:
> > On Sun, 24 Oct 1999, Mike Mascari wrote:
> >> So in the example you gave above, you could put a comment
> >> on each of the two functions which compose the operator
> >> and a command on the operator itself.
> 
> Two functions?  An operator only has one underlying function.
> (Aggregates have as many as three though.)
> 
> > Try \do and see for yourself. The fix should be rather simple but I'm not
> > sure where those descriptions are generated actually.
> 
> The default contents of pg_description come from the DESCR() macros in
> include/catalog/*.h.  It looks like only pg_proc and pg_type have any
> useful info in them in the current state of the source.  I'm guessing
> that psql's \do actually looks for a description attached to the
> underlying function, rather than one attached to the operator.

I can only get oids that are fixed in the include files.  Not sure if it
looks at the function behind the operator.  I just don't remember.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [PATCHES] COMMENT ON patch
Next
From: Bruce Momjian
Date:
Subject: Re: System indexes are never unique indexes( was RE: [HACKERS] mdnblocksis an amazing time sink in huge relations)