Skip site navigation (1) Skip section navigation (2)

Re: small ODBC problem

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: dduma(at)personaldb(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: small ODBC problem
Date: 2001-07-10 03:39:42
Message-ID: 3B4A78FE.F3732339@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org wrote:
> 
> Jaeho,Huh (dduma(at)personaldb(dot)net) reports a bug with a severity of 3
> The lower the number the more severe it is.
> 
> Short Description
> small ODBC problem
> 
> Long Description
> In console, if I execute the multiple statements including with one error statement, then all statements will succeed except the one error statement. ( Of courcse I didn't use the 'BEGIN WORK' )
> 
> But in ODBC, if I execute the multiple statements including with one error statement, then all of the statements will not succeed. In other words, multiple statements are executed in transaction state in ODBC though without 'BEGIN WORK'.
> 
> I think ODBC run should be the same with the console.
> 
> Is it a bug?
> 

A multi-statements query is treated as one command.
It's a spec of PostgreSQL though it's not well known.
Psql separates it into multiple commands and call
them one by one by itself.

regards,
Hiroshi Inoue

In response to

pgsql-bugs by date

Next:From: Ganesh PrasadDate: 2001-07-10 05:45:51
Subject: Polymorphism in the PostgreSQL object model
Previous:From: William M. ShubertDate: 2001-07-10 02:43:24
Subject: Corrupted index/unique column after vacuuming

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group