Postgres Pro
Downloads
Home   >   mailing lists

Update Help on PREPARE to mention DEALLOCATE - Mailing list pgsql-docs

From Kirk Wolak
Subject Update Help on PREPARE to mention DEALLOCATE
Date
Msg-id CACLU5mRsdYaEr+y=rYr6_rHJRoW49vTnSLdrcwwN2K0fONupJg@mail.gmail.com
Whole thread Raw
Responses Re: Update Help on PREPARE to mention DEALLOCATE
List pgsql-docs
Tree view
Please notice this exchange:

16:20:02 devuser@nctest= # \h deallocate
Command:     DEALLOCATE
Description: deallocate a prepared statement
Syntax:
DEALLOCATE [ PREPARE ] { name | ALL }

URL: https://www.postgresql.org/docs/16/sql-deallocate.html

16:20:11 devuser@nctest= # \h PREPARE
Command:     PREPARE
Description: prepare a statement for execution
Syntax:
PREPARE name [ ( data_type [, ...] ) ] AS statement

URL: https://www.postgresql.org/docs/16/sql-prepare.html

Notice.  The DEALLOCATE  shows [ PREPARE ]
Which is great because the two commands go together.
Unfortunately it's asymmetry is painful.  Because I ALWAYS remember PREPARE.
It's DEALLOCATE I always struggle to remember.

Could we make the PREPARE line read

PREPARE [ DEALLOCATE ] ...?

So it's more consistent, and the user using a PREPARE gets a clue to DEALLOCATE?

Thanks!

pgsql-docs by date:

Previous
From: Pavel Luzanov
Date:
Subject: pg_createsubscriber: A more precise link to the initial data sync
Next
From: "David G. Johnston"
Date:
Subject: Re: Update Help on PREPARE to mention DEALLOCATE