From: Apyo s.r.o. <apyo@apyo.sk>
To: pgsql-interfaces@postgresql.org
Subject: bug in postodbc
Date: Thu, 01 Oct 1998 17:23:42 +0200
Message-ID: <36139E7E.46865F55@apyo.sk> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: apyo@apyo.sk
Subject: Re: bug in postodbc
In-Reply-To: <36139E7E.46865F55@apyo.sk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox