Re: deallocate statement failing

On 2/6/20 9:02 PM, rob stone wrote:
> Hello,
>
> Version:-
>
>
> PostgreSQL 12.1 (Debian 12.1-2) on x86_64-pc-linux-gnu, compiled by gcc
> (Debian 9.2.1-22) 9.2.1 20200104, 64-bit
>
> Log:-
>
> 2020-02-07 15:42:55 AEDT LOG: statement: SELECT COUNT(*) AS ps_count
> FROM pg_prepared_statements WHERE name = 'AIT1581050529'
> 2020-02-07 15:42:55 AEDT ERROR: syntax error at or near
> "'AIT1581050529'" at character 13
> 2020-02-07 15:42:55 AEDT STATEMENT: DEALLOCATE 'AIT1581050529'
>

Try:

DEALLOCATE AIT1581050529;

>
> The deallocate statement fails. It doesn't matter if it is just
> "DEALLOCATE" or "DEALLOCATE PREPARE".
> We put in the count statement to make sure the prepared statement still
> existed and only issued the "DEALLOCATE" if ps_count is greater then
> zero.
>
> Does anybody know why it is giving this syntax error?
>
> TIA,
> Rob
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com