On Fri, 2020-02-07 at 00:48 -0500, Tom Lane wrote:
> 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
That worked. Thanks.