Re: deallocate statement failing

2020-02-06 Thread rob stone
On Fri, 2020-02-07 at 00:48 -0500, Tom Lane wrote: > rob stone 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

Re: deallocate statement failing

2020-02-06 Thread Tom Lane
rob stone 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 yo

Re: deallocate statement failing

2020-02-06 Thread Adrian Klaver
On 2/6/20 9:02 PM, rob stone wrote: 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 = 'AIT15810

deallocate statement failing

2020-02-06 Thread rob stone
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: