Update Help on PREPARE to mention DEALLOCATE

Поиск
Список
Период
Сортировка
От Kirk Wolak
Тема Update Help on PREPARE to mention DEALLOCATE
Дата
Msg-id CACLU5mRsdYaEr+y=rYr6_rHJRoW49vTnSLdrcwwN2K0fONupJg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Update Help on PREPARE to mention DEALLOCATE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-docs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Pavel Luzanov
Дата:
Сообщение: pg_createsubscriber: A more precise link to the initial data sync
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Update Help on PREPARE to mention DEALLOCATE