> On Apr 15, 2022, at 11:14 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > Rob Sargent <robjsargent@xxxxxxxxx> writes: >> 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) > > Hmm, it looks like \df does not cope well with spaces in the argument > list: > > regression=# \df genome_threshold_mono(text,text,double) > List of functions > Schema | Name | Result data type | Argument data types | Type > --------+------+------------------+---------------------+------ > (0 rows) > > regression=# \df genome_threshold_mono(text,text, double) > ERROR: invalid regular expression: parentheses () not balanced > > It's sending the server a bogus pattern in the second case. > I've not looked at the code yet, but this does seem like a > psql (not server) bug. > > As Adrian noted, you're not supposed to use parameter names > in \df, only their types. It seems like whitespace ought > to be allowed though. > > regards, tom lane Thank you. Much relieved. The no-space-no-names thing is suspicious. Away from desk just now but sure I’ve successfully cutpasted the arg list into \df calls Will test shortly
