pgsql: Doc: fix out-of-date example of SPI usage.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: fix out-of-date example of SPI usage.
Date: 2023-07-18 15:59:53
Message-ID: E1qLn7A-00087r-AJ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: fix out-of-date example of SPI usage.

The "count" argument of SPI_exec() only limits execution when
the query is actually returning rows. This was not the case
before PG 9.0, so this example was correct when written; but
we missed updating it in commit 2ddc600f8. Extend the example
to show the behavior both with and without RETURNING.

While here, improve the commentary and markup for the rest
of the example.

David G. Johnston and Tom Lane, per report from Curt Kolovson.
Back-patch to all supported branches.

Discussion: https://postgr.es/m/CANhYJV6HWtgz_qjx_APfK0PAgLUzY-2vjLuj7i_o=TZF1LAQew@mail.gmail.com

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/dc2d9efcb47eaff04f9c0213ed60a9b5eb8aa129

Modified Files
--------------
doc/src/sgml/spi.sgml | 48 +++++++++++++++++++++++++++++++++---------------
1 file changed, 33 insertions(+), 15 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2023-07-19 02:49:23 pgsql: Doc: Update the logical replication restriction w.r.t Replica Id
Previous Message Michael Paquier 2023-07-18 05:05:22 pgsql: Fix indentation in twophase.c