Fw: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"

> I think you should omit the word "RELEASE" after the
> "ROLLBACK".

Will this still result in the closed DB connection that the "ROLLBACK
RELEASE" used to give me?

Jason Alburger
HID/NAS/LAN Engineer
L3/ATO-E En Route Peripheral Systems Support
609-485-7225
----- Forwarded by Jason CTR Alburger/ACT/CNTR/FAA on 02/22/2006 10:20 AM
-----

Ludwig Isaac Lim
<ludz_lim(at)yahoo(dot)c
om> To
Jason CTR Alburger/ACT/CNTR/FAA(at)FAA
02/22/2006 10:15 cc
AM
Subject
Re: [GENERAL] ecpg error -->
DbPg_cre_sect_buf.pgc:1334: ERROR:
syntax error at or near "RELEASE"

Hi:

I think you should omit the word "RELEASE" after the
"ROLLBACK".

Ludwig Lim

--- jason(dot)ctr(dot)alburger(at)faa(dot)gov wrote:

>
>
>
>
> 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...
> .
> .
> .

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com