Re: Improving some plpgsql error messages

2021-08-20 Thread Robert Haas
On Fri, Aug 20, 2021 at 12:41 PM Pavel Stehule wrote: > It can be fixed in 14. This is a low risk patch. +1. -- Robert Haas EDB: http://www.enterprisedb.com

Re: Improving some plpgsql error messages

2021-08-20 Thread Pavel Stehule
pá 20. 8. 2021 v 17:50 odesílatel Tom Lane napsal: > In commit 2f48ede08 I copied some error-message wording that had > existed in exec_run_select() since 2003. I'm now dissatified > with that, after realizing that it can produce output like this: > > ERROR: query "WITH a AS ( > SELECT >

Re: Improving some plpgsql error messages

2021-08-20 Thread David G. Johnston
On Fri, Aug 20, 2021 at 8:50 AM Tom Lane wrote: > Thoughts? Should I back-patch this into v14 where 2f48ede08 > came in, or just do it in HEAD? > I'd say back-patch in the interest of preventing probably quite a few emails from novices at plpgsql coding dealing with all the interplay between qu

Improving some plpgsql error messages

2021-08-20 Thread Tom Lane
In commit 2f48ede08 I copied some error-message wording that had existed in exec_run_select() since 2003. I'm now dissatified with that, after realizing that it can produce output like this: ERROR: query "WITH a AS ( SELECT regexp_split_to_table(info_out, '\n') AS info FROM p