Re: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR:

jason(dot)ctr(dot)alburger(at)faa(dot)gov 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