deallocate statement failing
От | rob stone |
---|---|
Тема | deallocate statement failing |
Дата | |
Msg-id | c848191d39564916a0205ecd0c1336cb5f0bc929.camel@gmail.com обсуждение исходный текст |
Ответы |
Re: deallocate statement failing
Re: deallocate statement failing |
Список | 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
В списке pgsql-general по дате отправления: