From: | "Laurent Savary" <laurent_savary(at)no_spam(dot)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org |
Subject: | PostGreSql ODBC driver and Powerbuilder 7.0.3 problem |
Date: | 2002-06-26 13:32:29 |
Message-ID: | afcfo1$1nce$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi everybody,
I have the following problem with PostGreSql version 7.2.1 (on a Linux
Redhat 7.2) and Powerbuilder 7.0.3 (build 10108) when I use the ODBC driver
(7.02.00.01) for adding new row on a table which have (in the update
properties) an identity column.
The insert's command seems ok, but in the log file I have some strange
caracters :
pb70 1d1-17c ENTER SQLExecDirect
HSTMT 0BB32E88
UCHAR * 0x04E80EA0 [ -3] "INSERT INTO datetest2 (
dat_descr ) VALUES ( 'toto' )\ 0"
SDWORD -3
pb70 1d1-17c EXIT SQLExecDirect with return code 0
(SQL_SUCCESS)
HSTMT 0BB32E88
UCHAR * 0x04E80EA0 [ -3] "INSERT INTO datetest2 (
dat_descr ) VALUES ( 'toto' )\ 0"
SDWORD -3
pb70 1d1-17c ENTER SQLAllocStmt
HDBC 0BB31908
HSTMT * 0012E8F0
pb70 1d1-17c EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 0BB31908
HSTMT * 0x0012E8F0 ( 0x0bb338c0)
pb70 1d1-17c ENTER SQLExecDirect
HSTMT 0BB338C0
UCHAR * 0x0012E93C [ -3] "0\ 0"
SDWORD -3
pb70 1d1-17c EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 0BB338C0
UCHAR * 0x0012E93C [ -3] "0\ 0"
SDWORD -3
DIAG [S1000] ERROR: parser: parse error at or near "0" (7)
pb70 1d1-17c ENTER SQLFreeStmt
HSTMT 0BB338C0
UWORD 1 <SQL_DROP>
pb70 1d1-17c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0BB338C0
UWORD 1 <SQL_DROP>
pb70 1d1-17c ENTER SQLTransact
HENV 0BB341A0
HDBC 0BB31970
UWORD 0 <SQL_COMMIT>
With Dw which haven't identity column specified on update properties there
are no problem.
Does anybody have the same problem?
Thanks in advance
--
Laurent Savary
SA Medial
Note : remove no_spam for reply
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Sarmiento | 2002-06-26 13:39:04 | Strange behaviour of SELECT ... IN |
Previous Message | Markus Wollny | 2002-06-26 12:50:56 | Still problems with memory swapping and server load |