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.
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
