From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | function defined (or not), more worries on version 10->14 upgrade |
Date: | 2022-04-15 16:53:59 |
Message-ID: | 1c00b419-2507-f018-3579-2529ed8d6de5@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2022-04-15 17:01:16 | Re: function defined (or not), more worries on version 10->14 upgrade |
Previous Message | Adrian Klaver | 2022-04-15 15:59:17 | Re: Require details that can we see the password history to a User account in PostgreSQL Database. |