From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: function defined (or not), more worries on version 10->14 upgrade |
Date: | 2022-04-15 17:01:16 |
Message-ID: | 46aff424-7027-49a2-278c-4e8179306ac4@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2022-04-15 17:07:00 | Re: function defined (or not), more worries on version 10->14 upgrade |
Previous Message | Rob Sargent | 2022-04-15 16:53:59 | function defined (or not), more worries on version 10->14 upgrade |