Bugs item #1000641, was opened at 2006-05-10 02:51
You can respond by visiting:
http://pgfoundry.org/tracker/?func=d...oup_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: odbc can't execute next statement after execute a bad function

Initial Comment:
server :8.1.1
odbc sqlodbc 8.02.00.02
test tool: odbcte32.exe

after I execute a bad function
select bad_func()

I can't execute any statement , ODBC 's errmsg is "the cursor is open"

there is odbcte32 's log as below:
--------------------------------------------------------------
dbc: szSqlState = "01004", *pfNativeError = 215, *pcbErrorMsg = 27
MessageText = "the ConnStrOut is too small"
Full Connect:

Full Connect(Default)

Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

Successfully connected to DSN 'PostgreSQL Unicode'.
SQLExecDirect:
In: hstmt = 0x00C00394, szSqlStr = "select bad_func()",
cbSqlStr = -3
Return: SQL_ERROR=-1

Errors All:
: szSqlState = "42P01", *pfNativeError = 7, *pcbErrorMsg = 73
szErrorMsg = "ERROR: relation "notable" does not exist;
Error while executing the query"
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"


SQLExecDirect:
In: hstmt = 0x00C00394, szSqlStr = "select * from account",
cbSqlStr = -3
Return: SQL_ERROR=-1

Errors All:
: szSqlState = "HY010", *pfNativeError = 3, *pcbErrorMsg = 19
szErrorMsg = "The cursor is open."
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"
desc: szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this function"
--------------------------------------------------------------------------


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=d...oup_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match