42.6.8 trapping errors

On Saturday, November 14, 2020, PG Doc comments form <noreply@postgresql.org>
wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html
Description:

Hi
I think that section should have more examples with the most common errors,
like for example no_data_found when doing a select.

Why?

David J.

On 2020-11-15 04:39, David G. Johnston wrote:

On Saturday, November 14, 2020, PG Doc comments form
<noreply@postgresql.org <mailto:noreply@postgresql.org>> wrote:

The following documentation comment has been logged on the website:

Page:
https://www.postgresql.org/docs/13/plpgsql-control-structures.html
<https://www.postgresql.org/docs/13/plpgsql-control-structures.html&gt;
Description:

Hi
I think that section should have more examples with the most
common errors,
like for example no_data_found when doing a select.

Why?

David J.

I think it would be helpful from the perspective for an inexperienced user.

On Saturday, November 14, 2020, Post Gresql <postgresql@taljaren.se> wrote:

On 2020-11-15 04:39, David G. Johnston wrote:

On Saturday, November 14, 2020, PG Doc comments form <
noreply@postgresql.org> wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html
Description:

Hi
I think that section should have more examples with the most common
errors,
like for example no_data_found when doing a select.

Why?

David J.

I think it would be helpful from the perspective for an inexperienced user.

Doing “five whys” in email feels strange...

At least propose your idea of a comprehensive listing, i have no idea what
would be a common error - the feature itself is rarely used in the first
place. One plugs in whichever error is staring them in the face.

David J.