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

   barnard=# set search_path = shoc,base,public, bulk;
   SET
   barnard=# begin;
   BEGIN
   barnard=# select genome_threshold_mono('asdf', 'qewq');
   NOTICE:  group id is <NULL>
   ERROR:  Could not find markerset for qewq
   CONTEXT:  PL/pgSQL function threshold_process(uuid,text,boolean)
   line 11 at RAISE
   SQL statement "select threshold_process(tid, genome_name, false)"
   PL/pgSQL function genome_threshold_mono(text,text,double precision)
   line 22 at SQL statement
   SQL statement "select genome_threshold_mono(pbs_name, genome_name,
   1.96)"
   PL/pgSQL function genome_threshold_mono(text,text) line 5 at SQL
   statement
   barnard=# rollback;
   ROLLBACK
   barnard=# \df genome_threshold_mono(pbs_name text, genome_name text,
   conf double precision);
   ERROR:  invalid regular expression: parentheses () not balanced

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

Reply via email to