Re: PostgreSQL: SQLSetPos fails with SetPos update return error.

Hi Hiroshi,

Thanks for the response.

Below is the snippet of the MyLog output. Let me know what you find.

FYI: After I enable DB partitioning feature , I see this problem.

++++++++++++++++++++

[42328-902.543]libpq_bind_and_exec: execute stmt=000000000338A150

[42328-902.543]SC_scanQueryAndCountParams: entering...

[42328-902.543]SC_scanQueryAndCountParams: entering...

[42328-902.543]process_statements:parsed for the first command length=-1(-1) num_p=72

[42328-902.543]in QR_Constructor

[42328-902.543]exit QR_Constructor

[42328-902.543]num_fields = 1

[42328-902.543]in QR_set_num_fields

[42328-902.543]exit QR_set_num_fields

[42328-902.543]QR_from_PGResult: fieldname='ctid', adtid=27, adtsize=6, atttypmod=-1 (rel,att)=(710649,-1)

[42328-902.543]REALLOC: old_count = 0, size = 0

[42328-902.543]qresult: len=6, buffer='(0,18)'

[42328-902.543]qresult: len=5, buffer='(0,6)'

[42328-902.543]extend_column_bindings: entering ... self=000000000338A230, bindings_allocated=0, num_columns=1

[42328-902.543]exit extend_column_bindings=00000000017C1EE0

[42328-902.543]SC_set_Result(338a150, 3d49950)[42328-902.543]QResult: enter DESTRUCTOR

[42328-902.543]retval=0

[42328-902.543]PGAPI_ExecDirect: returned 0 from PGAPI_Execute

[42328-902.543]pos_update_callback in

[42328-902.543]STATEMENT ERROR: func=irow_update, desc='', errnum=7, errmsg='SetPos update return error'

[42328-902.543]CONN ERROR: func=irow_update, desc='', errnum=0, errmsg='(NULL)'

[42328-902.543]PGAPI_FreeStmt: entering...hstmt=000000000338A150, fOption=1

[42328-902.543]QResult: enter DESTRUCTOR

[42328-902.543]QResult: in QR_close_result

[42328-902.543]QResult: free memory in, fcount=2

[42328-902.543]QResult: free memory out

[42328-902.543]QResult: exit close_result

[42328-902.543]QResult: exit DESTRUCTOR

[42328-902.543]SC_init_Result(338a150)[42328-902.543]SC_Destructor: self=000000000338A150, self->result=0000000000000000, self->hdbc=00000000003D9020

[42328-902.543]reset_a_column_binding: entering ... self=000000000338A230, bindings_allocated=1, icol=1

[42328-902.543]APD_free_params:  ENTER, self=000000000338A310

[42328-902.543]APD_free_params:  EXIT

[42328-902.559]IPD_free_params:  ENTER, self=000000000338A380

[42328-902.559]IPD_free_params:  EXIT

[42328-902.559]PDATA_free_params:  ENTER, self=000000000338A470

[42328-902.559]PDATA_free_params:  EXIT

[42328-902.559]SC_Destructor: EXIT

[42328-902.559]PGAPI_SetPos returning -1

[42328-902.559][SQLGetDiagRecW][42328-902.559]PGAPI_GetDiagRec entering type=3 rec=1

[42328-902.559]ER_ReturnError: status = 7, msg = #SetPos update return error#

[42328-902.559]                     szSqlState = 'HY000',len=26, szError='SetPos update return error'

[42328-902.559]PGAPI_GetDiagRec exiting 0

[42328-902.559][[SQLFreeHandle]][42328-902.559]PGAPI_FreeStmt: entering...hstmt=0000000003388950, fOption=1

[42328-902.559]QResult: enter DESTRUCTOR

[42328-902.559]QResult: in QR_close_result

[42328-902.559]QResult: free memory in, fcount=1

[42328-902.559]CC_send_query: conn=00000000003D9020, query='DEALLOCATE "_KEYSET_0000000003238830"'

[42328-902.559]in QR_Constructor

[42328-902.559]exit QR_Constructor

[42328-902.559]send_query: ok - 'C' - SAVEPOINT

[42328-902.559]send_query: setting cmdbuffer = 'SAVEPOINT'

[42328-902.559]send_query: ok - 'C' - DEALLOCATE

[42328-902.559]send_query: setting cmdbuffer = 'DEALLOCATE'

[42328-902.559]send_query: returning res = 0000000003D496B0

[42328-902.559]send_query: ok - 'C' - RELEASE

[42328-902.559]in QR_Constructor

[42328-902.559]exit QR_Constructor

[42328-902.559]send_query: setting cmdbuffer = 'RELEASE'

[42328-902.559]send_query: returning res = 0000000003D48ED0

[42328-902.559]QResult: enter DESTRUCTOR

[42328-902.559]QResult: in QR_close_result

[42328-902.559]QResult: free memory in, fcount=0

[42328-902.559]QResult: free memory out

++++++++++++++++

Hi Sekhar,

Hi Guys,

 

I am hitting a peculiar error when trying to update a row in PostgreSQL database using odbc SQLSetPos call.

I read in PostgreSQL forums that it doesn’t support POSITIONED UPDATE.

 

The error being returned is:

 

STATE=HY000, CODE=7, MSG=SetPos update return error\n" ...} }

Are there any other error messages?
If there's no other message, could you take Mylog output and send it to me?

regards,
Hiroshi Inoue