Re: function defined (or not), more worries on version 10->14 upgrade

On 4/15/22 9:53 AM, Rob Sargent wrote:
> The function in question is working but I'm having trouble getting at 
> it's current definition and the possibility that there are more v10->v14 
> issues in this database.  The last ERROR: below seems to me "a system 
> thing"(tm)
> 
> 
> 
>     barnard=# \df genome_threshold_mono
>                                                       List of functions
>       Schema |         Name          | Result data type
>     |                  Argument data types                   | Type
>
--------+-----------------------+------------------+--------------------------------------------------------+------
>       public | genome_threshold_mono | uuid             | pbs_name text,
>     genome_name text                        | func
>       public | genome_threshold_mono | uuid             | pbs_name text,
>     genome_name text, conf double precision | func
>     (2 rows)
> 
>     barnard=# \df genome_threshold_mono(pbs_name text, genome_name text,
>     conf double precision);
>     ERROR:  invalid regular expression: parentheses () not balanced

Don't use the column names just the data types:

\df genome_threshold_mono(text, text, double precision);

> The supplied arguments to the function in question are obviously bogus, 
> but the reaction is correct, including call to nested functions.


-- 
Adrian Klaver
adrian.klaver@aklaver.com