DOCS - "Get Object DDL Functions" table improvements

Started by Peter Smithabout 1 month ago5 messageshackers
Jump to latest
#1Peter Smith
smithpb2250@gmail.com

As discussed in another thread [1]/messages/by-id/8733yw55id.fsf@gmail.com, I propose some minor docs changes
for the new DDL functions table.

1. Arrange table 9.96 alphabetically.

2. Add helpful links back to the commands that these functions are generating.

~~~

PSA v1 patches to do the above

======
[1]: /messages/by-id/8733yw55id.fsf@gmail.com

Kind Regards,
Peter Smith.
Fujitsu Australia

Attachments:

v1-0001-Make-the-DDL-functions-table-alphabetical.patchapplication/octet-stream; name=v1-0001-Make-the-DDL-functions-table-alphabetical.patchDownload+23-24
v1-0002-Add-links-to-the-DDL-commands-being-generated.patchapplication/octet-stream; name=v1-0002-Add-links-to-the-DDL-commands-being-generated.patchDownload+7-8
#2Ian Lawrence Barwick
barwick@gmail.com
In reply to: Peter Smith (#1)
Re: DOCS - "Get Object DDL Functions" table improvements

2026年6月11日(木) 10:54 Peter Smith <smithpb2250@gmail.com>:

As discussed in another thread [1], I propose some minor docs changes
for the new DDL functions table.

For reference, this is the table:

https://www.postgresql.org/docs/19/functions-info.html#FUNCTIONS-GET-OBJECT-DDL

1. Arrange table 9.96 alphabetically.

I'm working on a patch that touches this table and noticed the arbitrary order,
so +1 for reordering.

2. Add helpful links back to the commands that these functions are generating.

Makes sense to me; on the same page I see we don't always back-link items
including SQL commands, but IMO links are one of the features of this
new-fangled
hypertext thing.

It would certainly worth getting the changes in, also as a template for future
patches which touch the table. It might be worth combining the two patches.
There doesn't seem to be a commitfest entry.

Regards

Ian Barwick

#3Peter Smith
smithpb2250@gmail.com
In reply to: Ian Lawrence Barwick (#2)
Re: DOCS - "Get Object DDL Functions" table improvements

On Sat, Jun 27, 2026 at 7:46 AM Ian Lawrence Barwick <barwick@gmail.com> wrote:

...

It would certainly worth getting the changes in, also as a template for future
patches which touch the table. It might be worth combining the two patches.
There doesn't seem to be a commitfest entry.

Hi Ian.

Thanks for your review.

A rebase was needed, and patches have been merged as suggested.

Commitfest entry added [1]https://commitfest.postgresql.org/patch/6947/.

======
[1]: https://commitfest.postgresql.org/patch/6947/

Kind Regards,
Peter Smith.
Fujitsu Australia

Attachments:

v2-0001-DOCS-Make-DDL-function-table-alphabetical-and-add.patchapplication/octet-stream; name=v2-0001-DOCS-Make-DDL-function-table-alphabetical-and-add.patchDownload+42-40
#4Michael Paquier
michael@paquier.xyz
In reply to: Peter Smith (#3)
Re: DOCS - "Get Object DDL Functions" table improvements

On Mon, Jun 29, 2026 at 11:01:07AM +1200, Peter Smith wrote:

A rebase was needed, and patches have been merged as suggested.

Applied...

Commitfest entry added [1].

======
[1] https://commitfest.postgresql.org/patch/6947/

... And adjusted accordingly.
--
Michael

#5Peter Smith
smithpb2250@gmail.com
In reply to: Michael Paquier (#4)
Re: DOCS - "Get Object DDL Functions" table improvements

On Mon, Jun 29, 2026 at 4:15 PM Michael Paquier <michael@paquier.xyz> wrote:

On Mon, Jun 29, 2026 at 11:01:07AM +1200, Peter Smith wrote:

A rebase was needed, and patches have been merged as suggested.

Applied...

Thanks for pushing.

======
Kind Regards,
Peter Smith.
Fujitsu Australia