Hello, This is an actual problem that our customer hit. In ECPG, opening a cursor fails which is declared as follows:
EXEC SQL DECLARE cur CURSOR FOR
SELECT oid, datname
FROM pg_database
WHERE datname LIKE 'post%' ESCAPE '\' AND datconnlimit =
:connlimit;
sqlstate: 07001
sqlerrm.sqlerrmc: too many arguments on line 30
The cause is that next_insert() in ecpglib unconditionally skips the next
character after the backslash.
Could you review and commit the attached patch? I also attached the test
program for convenience.
Regards
Takayuki Tsunakawa
ecpg_escape_string.patch
Description: ecpg_escape_string.patch
escape.ec
Description: escape.ec
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
