Re: Update Help on PREPARE to mention DEALLOCATE

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Update Help on PREPARE to mention DEALLOCATE
Дата
Msg-id CAKFQuwa0CdWC2wsaGBdiBd22AvOShy=qnDU-fpkNj_3cfc8RzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Update Help on PREPARE to mention DEALLOCATE  (Kirk Wolak <wolakk@gmail.com>)
Ответы Re: Update Help on PREPARE to mention DEALLOCATE  (Kirk Wolak <wolakk@gmail.com>)
Список pgsql-docs
On Tue, Apr 16, 2024 at 1:27 PM Kirk Wolak <wolakk@gmail.com> wrote:
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?


No. That is a syntax excerpt and the prepare command doesn't accept an optional deallocate keyword at that position.

If we wanted to improve the psql help here we'd have two options:
Add to the description:
prepare a statement for execution (undo this with Deallocate)

or teach our build system to add our "see also" section to the psql help pages.

The second seems reasonable but non-trivial.  The first just seems odd when reading the website.

There may be a third option but I actually haven't ever explored the psql help build module.

David J.
 

В списке pgsql-docs по дате отправления:

Предыдущее
От: Kirk Wolak
Дата:
Сообщение: Update Help on PREPARE to mention DEALLOCATE
Следующее
От: Kirk Wolak
Дата:
Сообщение: Re: Update Help on PREPARE to mention DEALLOCATE