| From: | rob stone <floriparob(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: deallocate statement failing |
| Date: | 2020-02-07 06:46:25 |
| Message-ID: | 1c6aff52e04120962eef422db8f31fb40bd64dc3.camel@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2020-02-07 at 00:48 -0500, Tom Lane wrote:
> rob stone <floriparob(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Withers | 2020-02-07 08:35:45 | sensible configuration of max_connections |
| Previous Message | Tom Lane | 2020-02-07 05:48:42 | Re: deallocate statement failing |