Re: Do we need use more meaningful variables to replace 0 in catalog head files?

On 11/11/2016 11:10 AM, Tom Lane wrote:
> boolin: OID=1242 proname=boolin proargtypes="cstring" prorettype=bool
> boolin: prosrc=boolin provolatile=i proparallel=s
>
>


I have written a little perl script to turn the pg_proc DATA lines into
something like the format suggested. In order to keep the space used as
small as possible, I used a prefix based on the OID. See attached result.

Still plenty of work to go, e.g. grabbing the DESCR lines, and turning
this all back into DATA/DESCR lines, but I wanted to get this out there
before going much further.

The defaults I used are below (commented out keys are not defaulted,
they are just there for completeness).

    my %defaults = (
    #                oid =>
    #                name =>
                     namespace => 'PGNSP',
                     owner => 'PGUID',
                     lang => '12',
                     cost => '1',
                     rows => '0',
                     variadic => '0',
                     transform => '0',
                     isagg => 'f',
                     iswindow => 'f',
                     secdef => 'f',
                     leakproof => 'f',
                     isstrict => 'f',
                     retset => 'f',
                     volatile => 'v',
                     parallel => 'u',
    #                nargs =>
                     nargdefaults => '0',
    #                rettype =>
    #                argtypes =>
                     allargtypes => '_null_',
                     argmodes => '_null_',
                     argnames => '_null_',
                     argdefaults => '_null_',
                     trftypes => '_null_',
    #                src =>
                     bin => '_null_',
                     config => '_null_',
                     acl => '_null_',
    );


cheers

andrew