jason.ctr.alburger@xxxxxxx writes: > I'm relatively new to database programming & I've inherited a system to > maintain that contains lots of embedded SQL. I'm attempting to port my C > source code from RH 7.2 (with ecpg 2.8.0) to Mandrake 10.0 (with ecpg > 4.1.1). ecpg 4.1.1 is generating an error which I did not get on the > RH7.2 system with ecpg 2.8.0....It's telling me I have a syntax error with > a "ROLLBACK RELEASE" (DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or > near "RELEASE"). Here's a snippet of the code in error... I think RELEASE is now a reserved word (referring to savepoints) so you should probably just change the code to use 'ROLLBACK;'. -Doug
