function defined (or not), more worries on version 10->14 upgrade

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.

Responses

Browse pgsql-general by date

  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.