Received: from sql.sknet.net ([195.12.133.42])
	by hub.org (8.8.8/8.8.8) with ESMTP id LAA20669
	for <pgsql-interfaces@postgresql.org>;
	Thu, 1 Oct 1998 11:21:42 -0400 (EDT) (envelope-from apyo@apyo.sk)
Received: from WinProxy.anywhere (FIRST [195.12.134.47]) by sql.sknet.net with
	SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2232.9)
	id T6ZR3ABQ; Thu, 1 Oct 1998 17:16:02 +0200
Received: from 192.168.100.1 by 192.168.100.1 (WinProxy);
	Thu, 1 Oct 1998 17:23:42 +0100
Message-ID: <36139E7E.46865F55@apyo.sk>
Date: Thu, 01 Oct 1998 17:23:42 +0200
From: "Apyo s.r.o." <apyo@apyo.sk>
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: bug in postodbc
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

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