From: | "Apyo s(dot)r(dot)o(dot)" <apyo(at)apyo(dot)sk> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | bug in postodbc |
Date: | 1998-10-01 15:23:42 |
Message-ID: | 36139E7E.46865F55@apyo.sk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
I woud like ot report a bug in Postgresql ODBC driver. I use postgresql
ver 6.3 and ODBC driver version 6.30.0250 and MS ACCESS 97. When I try
to insert backslash \ into a varchar field in linked table through MS
ACCESS it doesn't work. Error messages :
ODBC-insert on a linked table 'test' failed.
Error while executing the query;
ERROR: parser: parse error at or near "" (#1)
And a piece of psqlodbc.log
conn=37558536, query='BEGIN'
conn=37558536, query='INSERT INTO "test" ("a") VALUES ('\')'
ERROR from backend during send_query: 'ERROR: parser: parse error at or
near ""'
conn=37558536, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'
------------------------------------------------------------
hdbc=37558536, stmt=37683416, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=37554272, parameters_allocated=1
statement_type=1, statement='INSERT INTO "test" ("a")
VALUES (?)'
stmt_with_params='INSERT INTO "test" ("a") VALUES
('\')'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR023F00D8'
----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR: parser:
parse error at or near ""'
------------------------------------------------------------
henv=37553728, conn=37558536, status=1, num_stmts=16
sock=37553744, stmts=37553792, lobj_type=-999
---------------- Socket Info -------------------------------
socket=336, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=37564832, buffer_out=37568936
buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2
Is this really a bug?
Tibor Arpas
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-10-02 19:16:30 | Re: [INTERFACES] jdbc driver |
Previous Message | Pontus Lidman | 1998-10-01 14:10:38 | Problems using Insights ODBC with Microsoft Project |