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

[Catching up on my old email, well at least sort of. Sorry for the
delay.]

On Wed, Feb 22, 2006 at 10:22:39AM -0500, jason.ctr.alburger@faa.gov wrote:
> Will this still result in the closed DB connection that the "ROLLBACK
> RELEASE" used to give me?

ECPG just sends the queries to the backend the way you write them. It
does some parsing so you can be noticed if there are syntax errors. It
also does some translations to get the C variables into the SQL code and
vica versa, but all other statement with the exception of
prepare/execute are transferred as-is. Or at least that should be the
case. :-)

So to see if ROLLBACK has the behaviour you need you have to check the
backend documentation.

Michael

--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!