pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: Fix catalog data of pg_stop_backup(), labelled v2
3+ messages / 2 participants
[nested] [flat]

Commits from this thread:
  2022-03-04 b3c8aae008  doc: Fix description of pg_stop_backup()
* pgsql: Fix catalog data of pg_stop_backup(), labelled v2
@ 2022-03-03 01:53 Michael Paquier <michael@paquier.xyz>
  2022-03-03 15:09 ` Re: pgsql: Fix catalog data of pg_stop_backup(), labelled v2 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Michael Paquier @ 2022-03-03 01:53 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Fix catalog data of pg_stop_backup(), labelled v2

This function has been incorrectly marked as a set-returning function
with prorows (estimated number of rows) set to 1 since its creation in
7117685, that introduced non-exclusive backups.  There is no need for
that as the function is designed to return only one tuple.

This commit fixes the catalog definition of pg_stop_backup_v2() so as it
is not marked as proretset anymore, with prorows set to 0.  This
simplifies its internals by removing one tuplestore (used for one single
record anyway) and by removing all the checks related to a set-returning
function.

Issue found during my quest to simplify some of the logic used in
in-core system functions.

Bump catalog version.

Reviewed-by: Aleksander Alekseev, Kyotaro Horiguchi
Discussion: https://postgr.es/m/Yh8guT78f1Ercfzw@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/62ce0c758d5d66092efbca7d037233e2ca9bdc78

Modified Files
--------------
src/backend/access/transam/xlogfuncs.c   | 36 ++++++--------------------------
src/backend/catalog/system_functions.sql |  2 +-
src/include/catalog/catversion.h         |  2 +-
src/include/catalog/pg_proc.dat          |  6 +++---
4 files changed, 11 insertions(+), 35 deletions(-)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pgsql: Fix catalog data of pg_stop_backup(), labelled v2
  2022-03-03 01:53 pgsql: Fix catalog data of pg_stop_backup(), labelled v2 Michael Paquier <michael@paquier.xyz>
@ 2022-03-03 15:09 ` Tom Lane <tgl@sss.pgh.pa.us>
  2022-03-04 00:53   ` Re: pgsql: Fix catalog data of pg_stop_backup(), labelled v2 Michael Paquier <michael@paquier.xyz>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2022-03-03 15:09 UTC (permalink / raw)
  To: Michael Paquier <michael@paquier.xyz>; +Cc: pgsql-committers@lists.postgresql.org

Michael Paquier <michael@paquier.xyz> writes:
> Fix catalog data of pg_stop_backup(), labelled v2

func.sgml also needs to be fixed, as it says the result
is "setof record".

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pgsql: Fix catalog data of pg_stop_backup(), labelled v2
  2022-03-03 01:53 pgsql: Fix catalog data of pg_stop_backup(), labelled v2 Michael Paquier <michael@paquier.xyz>
  2022-03-03 15:09 ` Re: pgsql: Fix catalog data of pg_stop_backup(), labelled v2 Tom Lane <tgl@sss.pgh.pa.us>
@ 2022-03-04 00:53   ` Michael Paquier <michael@paquier.xyz>
  0 siblings, 0 replies; 3+ messages in thread

From: Michael Paquier @ 2022-03-04 00:53 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-committers@lists.postgresql.org

On Thu, Mar 03, 2022 at 10:09:40AM -0500, Tom Lane wrote:
> func.sgml also needs to be fixed, as it says the result
> is "setof record".

Thanks, fixed.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2022-03-04 00:53 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-03-03 01:53 pgsql: Fix catalog data of pg_stop_backup(), labelled v2 Michael Paquier <michael@paquier.xyz>
2022-03-03 15:09 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-03-04 00:53   ` Michael Paquier <michael@paquier.xyz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox