Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[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@xxxxxxx 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@xxxxxxxxxx
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux