asynchronous support

Hi,

I wanted to lock a table from one application and insert some data. And my
requirement is, if that table is already locked by anyother process then I
need to try to lock after a specific amount of time.

I am using unixODBC driver in centOS machine and my database is postgresql.
I did a research on how to execute a sql asynchronously using odbc api. I
found SQLSetStmtAttr api can be used to execute the sql statement
asynchronously. But its not working.

This is how I wrote the code

ret = SQLSetStmtAttr( stmt1, SQL_ATTR_ASYNC_ENABLE,(SQLPOINTER)
SQL_ASYNC_ENABLE_ON, 0);
// above statement returned 0 which means success

if((ret = SQLExecDirect(stmt1,"lock table test",SQL_NTS)) ==
SQL_STILL_EXECUTING)
{
printf("\nCanceling\n");
ret = SQLCancel(stmt);
}

But process is getting hang on SQLExecDirect api, as that table "test"
is already locked by another process. (Hang in the sense, waiting for
all other processes to release the lock)

Why is it so ? Is that because my unixODBC driver does not support
asynchronous execution. if its so why SQLSetStmtAttr is returning
success ?

Any help is greatly appreciated. Thanks in advance.

--

Regards,
Radhesh Krishnan K.