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

2022-04-15 Thread Tom Lane
"David G. Johnston" writes: > ... And if I know something exists > in the DB and I want details, doing a name-only search followed by \sf > seems like it would work well enough. It could work better though. For example, regression=# \df *backup*

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

2022-04-15 Thread David G. Johnston
On Fri, Apr 15, 2022 at 3:02 PM Rob Sargent wrote: > On 4/15/22 15:52, David G. Johnston wrote: > > > > On Fri, Apr 15, 2022 at 2:30 PM Rob Sargent wrote: > >> On 4/15/22 15:18, David G. Johnston wrote: >> >> On Fri, Apr 15, 2022 at 2:04 PM Rob Sargent >> wrote: >> >>> but have not found a comb

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

2022-04-15 Thread Tom Lane
"David G. Johnston" writes: > On Fri, Apr 15, 2022 at 2:20 PM Tom Lane wrote: >> While I've not yet looked at the code, I've got no reason to think >> this is anything except fragile argument parsing in \df and \sf. > I'm unsure about the "extra argument ignored" bit but the rest of "not > found

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

2022-04-15 Thread Rob Sargent
On 4/15/22 15:52, David G. Johnston wrote: On Fri, Apr 15, 2022 at 2:30 PM Rob Sargent wrote: On 4/15/22 15:18, David G. Johnston wrote: On Fri, Apr 15, 2022 at 2:04 PM Rob Sargent wrote: but have not found a combination of name/args for genome_threshold_mono(te

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

2022-04-15 Thread David G. Johnston
On Fri, Apr 15, 2022 at 2:30 PM Rob Sargent wrote: > On 4/15/22 15:18, David G. Johnston wrote: > > On Fri, Apr 15, 2022 at 2:04 PM Rob Sargent wrote: > >> but have not found a combination of name/args for >> genome_threshold_mono(text,text,double >> precision) >> >> > Per the fine documentatio

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

2022-04-15 Thread Rob Sargent
On 4/15/22 15:18, David G. Johnston wrote: On Fri, Apr 15, 2022 at 2:04 PM Rob Sargent wrote: but have not found a combination of name/args for genome_threshold_mono(text,text,double precision) Per the fine documentation: \df[anptwS+] [ pattern [ arg_pattern ... ] ] So the correct f

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

2022-04-15 Thread David G. Johnston
On Fri, Apr 15, 2022 at 2:20 PM Tom Lane wrote: > Rob Sargent writes: > > I'm about to unleash new versions of the above and related functions > > (args will change), so a drops are imminent. Any reason to hold off on > that? > > While I've not yet looked at the code, I've got no reason to think

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

2022-04-15 Thread Tom Lane
Rob Sargent writes: > I'm about to unleash new versions of the above and related functions > (args will change), so a drops are imminent. Any reason to hold off on that? While I've not yet looked at the code, I've got no reason to think this is anything except fragile argument parsing in \df and

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

2022-04-15 Thread David G. Johnston
On Fri, Apr 15, 2022 at 2:04 PM Rob Sargent wrote: > but have not found a combination of name/args for > genome_threshold_mono(text,text,double > precision) > > Per the fine documentation: \df[anptwS+] [ pattern [ arg_pattern ... ] ] So the correct formulation is: \df genome_threshold_mono te

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

2022-04-15 Thread Rob Sargent
On 4/15/22 14:22, Adrian Klaver wrote: On 4/15/22 10:14, Tom Lane wrote: Rob Sargent 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

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

2022-04-15 Thread Adrian Klaver
On 4/15/22 10:14, Tom Lane wrote: Rob Sargent 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 l

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

2022-04-15 Thread Rob Sargent
> On Apr 15, 2022, at 11:14 AM, Tom Lane wrote: > > Rob Sargent 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 sys

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

2022-04-15 Thread Tom Lane
Rob Sargent 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

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

2022-04-15 Thread Adrian Klaver
On 4/15/22 9:53 AM, Rob Sargent wrote: 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_thre

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

2022-04-15 Thread Adrian Klaver
On 4/15/22 9:53 AM, Rob Sargent wrote: 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_thr

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

2022-04-15 Thread Rob Sargent
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