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