| From: | rob stone <floriparob(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | deallocate statement failing |
| Date: | 2020-02-07 05:02:05 |
| Message-ID: | c848191d39564916a0205ecd0c1336cb5f0bc929.camel@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
Version:-
PostgreSQL 12.1 (Debian 12.1-2) on x86_64-pc-linux-gnu, compiled by gcc
(Debian 9.2.1-22) 9.2.1 20200104, 64-bit
Log:-
2020-02-07 15:42:55 AEDT LOG: statement: SELECT COUNT(*) AS ps_count
FROM pg_prepared_statements WHERE name = 'AIT1581050529'
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".
We put in the count statement to make sure the prepared statement still
existed and only issued the "DEALLOCATE" if ps_count is greater then
zero.
Does anybody know why it is giving this syntax error?
TIA,
Rob
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-02-07 05:15:03 | Re: deallocate statement failing |
| Previous Message | Ken Tanzer | 2020-02-07 01:29:02 | Re: POLL: Adding transaction status to default psql prompt |