rob stone <floriparob@xxxxxxxxx> 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
