Repost: problem on treatment when add a duplicate primary key
От | Support |
---|---|
Тема | Repost: problem on treatment when add a duplicate primary key |
Дата | |
Msg-id | 000a01c2cdf6$7bd068e0$80faabc8@insyde обсуждение исходный текст |
Ответ на | Fw: problem on treatment when add a duplicate primary key ("Support" <support@insyde.com.br>) |
Список | pgsql-odbc |
Hi, I'm getting an error when I try to insert a duplicated value in a primary key or unique index. I know I can't insert so I'll explain the thing: When I insert the first time the row, it works but if I try to re-insert it simply crashes my application, giving me errors that I couldn't treat (I can treat this error in MSSQL ODBC Driver and MySQL ODBC Driver). I'm using 04/02/2003 CVS version Browsing the source I found that this was missing (please correct if wrong): environ.c case ERROR_DUPLICATED_ENTRY: pg_sqlstate_set(szSqlState, "23000", "S1010"); // entry already exists break; case ERROR_DUPLICATED_KEY: pg_sqlstate_set(szSqlState, "23000", "S1010"); // key already exists break; statement.h #define ERRROR_DUPLICATED_ENTRY 34 #define ERRROR_DUPLICATED_KEY 35 (next numbers of the sequence) I'm still investigating, but if any of you know about it, let me know. I also don't know if ERRROR_DUPLICATED_ENTRY and ERRROR_DUPLICATED_KEY are valid return codes and where to put them. If someone can help. TIA, Ricardo
В списке pgsql-odbc по дате отправления: