maciej-izak

PostgreSQL missing update for LastUpdateCount

PostgreSQL AV error during connection/reconnection

PostgreSQL error during connection/reconnection

PostgreSQL and problem with $ for functions

Tested with my code, works fine now! Thanks!

I am using trunk (my own clone repo synced with Zeos trunk : https://github.com/newpascal-ccr/zeos ). I have the same error ( 42601 ) : "cannot insert multiple commands in one prepared statement"

For the ZeosLib the problematic part seems $BODY$ , for exaple : CREATE OR REPLACE FUNCTION pc_chartoint(chartoconvert character varying) RETURNS integer AS ' SELECT CASE WHEN trim($1) SIMILAR TO ''[0-9]+'' THEN CAST(trim($1) AS integer) ELSE NULL END; ' LANGUAGE 'sql' IMMUTABLE STRICT; INSERT INTO servupgrade(nrop, query) values (261,''); works fine, also this is correct too: CREATE OR REPLACE FUNCTION pc_chartoint(chartoconvert character varying) RETURNS integer AS $BODY$ SELECT CASE WHEN trim(chartoconvert)...

Hi Jan, thanks for suggestion, in my case is used TZQuery. The problem is significant because I can't edit all SQLs, also TZQuery is used in many places in code (big legacy project) and can't be replaced in simple way... The problem is somewhere in Zeos, mentioned SQL code works for many years for me and with many Zeos versions.