BUG #6428: pg_restore -l not consistent with function comments - Mailing list pgsql-bugs

From keith@omniti.com
Subject BUG #6428: pg_restore -l not consistent with function comments
Date
Msg-id E1Rsi4j-00038m-Vc@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6428
Logged by:          Keith
Email address:      keith@omniti.com
PostgreSQL version: 9.1.2
Operating system:   Any
Description:=20=20=20=20=20=20=20=20

Working on a tool that iterates through the pg_restore -l list for doing
more advanced dump filtering (pg_extractor), I came across an inconsistency
in the object list that is generated. If a function is declared with the
argument variable names defined in the argument list, and has an associated
comment, the line for the comment in the pg_restore -l list includes the
variable name in the argument list whereas the line for the function itself
just has the argument types. This has made it hard for me to match comments
with functions. It just seems very inconsistent as well since the function
signature does not require the argument variable names to uniquely identify
it. Not a hugely critical item, but it's made it hard for me to make my
filtering tool as useful as I'd like it to be.

Example:
14663; 1255 16507 FUNCTION keith do_something(integer, text) postgres
48818; 0 0 COMMENT keith FUNCTION do_something(data_source_id integer, query
text) postgres

pgsql-bugs by date:

Previous
From: "bdmytrak@eranet.pl"
Date:
Subject: Re: BUG #6421: Revoke column level privilage
Next
From: Tom Lane
Date:
Subject: Re: BUG #6200: standby bad memory allocations on SELECT