bug in postodbc

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

Browse pgsql-interfaces by date

  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