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 balancedThe supplied arguments to the function in question are obviously bogus, but the reaction is correct, including call to nested functions.
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)
- function defined (or not), more worries on version 10-&g... Rob Sargent
- Re: function defined (or not), more worries on vers... Adrian Klaver
- Re: function defined (or not), more worries on vers... Adrian Klaver
- Re: function defined (or not), more worries on vers... Tom Lane
- Re: function defined (or not), more worries on ... Rob Sargent
- Re: function defined (or not), more worries on ... Adrian Klaver
- Re: function defined (or not), more worries... Rob Sargent
- Re: function defined (or not), more wor... David G. Johnston
- Re: function defined (or not), mor... Rob Sargent
- Re: function defined (or not),... David G. Johnston
- Re: function defined (or n... Rob Sargent