Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18694: DISCARD ALL does not reset execution counters for plpgsql functions - Mailing list pgsql-bugs

From David Pavlíček
Subject Re: BUG #18694: DISCARD ALL does not reset execution counters for plpgsql functions
Date
Msg-id CALZBrDXKeOTR1fPeNkzPMW=6GkRNDHukREAdfEYojzXLmy-UBg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18694: DISCARD ALL does not reset execution counters for plpgsql functions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #18694: DISCARD ALL does not reset execution counters for plpgsql functions
List pgsql-bugs
Tree view
In my opinion it is a bug. Documentation clearly states that DISCARD ALL "resets the session to its initial state", which is not true. So either it's a documentation error and DISCARD ALL isn't meant to completely reset the state, or it's meant to completely reset the state and then it's a bug in its implementation (whether it is a missing feature or bug in existing one). I agree that Implementing a new user-exposed command and then calling it within DISCARD ALL is probably the right solution to the problem.

David P.

čt 7. 11. 2024 v 14:38 odesílatel David G. Johnston <david.g.johnston@gmail.com> napsal:
On Thursday, November 7, 2024, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18694
Logged by:          David Pavlíček
Email address:      pavlicek.david@gmail.com
PostgreSQL version: 13.13
Operating system:   Linux
Description:       

In my opinion, the DISCARD ALL command should reset the internal
execution counters of plpgsql functions.


To my knowledge there is no user-exposed way to reset those counters.  Thus discard all cannot reset them.  It is a missing feature, not a bug.  One that I agree makes sense to add.

David J.
 

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18692: Segmentation fault when extending a varchar column with a gist index with custom signal length
Next
From: Alexander Korotkov
Date:
Subject: Re: BUG #18692: Segmentation fault when extending a varchar column with a gist index with custom signal length