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

From Michael Meskes
Subject Re: Fw: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"
Date
Msg-id 20060316084232.GD24681@1
Whole thread Raw
In response to Fw: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"  (jason.ctr.alburger@faa.gov)
List pgsql-general
[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!

pgsql-general by date:

Previous
From: SunWuKung
Date:
Subject: pgsql variables from records
Next
From: "vinod kumar bapure"
Date:
Subject: Query