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