Re: deallocate statement failing

rob stone <floriparob@gmail.com> writes:
> 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'

> The deallocate statement fails. It doesn't matter if it is just
> "DEALLOCATE" or "DEALLOCATE PREPARE".

I think you want double quotes not single quotes.  The argument
of DEALLOCATE is an SQL identifier, not a string literal.

            regards, tom lane