Re: Update Help on PREPARE to mention DEALLOCATE

2024-04-17 Thread Kirk Wolak
On Tue, Apr 16, 2024 at 4:42 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Apr 16, 2024 at 1:27 PM Kirk Wolak wrote: > >> Could we make the PREPARE line read >> ... >> > No. That is a syntax excerpt and the prepare command doesn't accept an > optional deallocate keyword at t

Re: Update Help on PREPARE to mention DEALLOCATE

2024-04-16 Thread David G. Johnston
On Tue, Apr 16, 2024 at 1:27 PM Kirk Wolak 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 deallo

Update Help on PREPARE to mention DEALLOCATE

2024-04-16 Thread Kirk Wolak
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: