rob stone <[email protected]> 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
