[EMAIL PROTECTED] wrote: > > Jaeho,Huh ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster