Problems with PsqlOdbc. - Mailing list pgsql-odbc

From Cleber Nardelli
Subject Problems with PsqlOdbc.
Date
Msg-id f90442ed050928161427299e9d@mail.gmail.com
Whole thread Raw
List pgsql-odbc
Hi...
Dave, I am with 2 problems how much to Driver ODBC.  Already I placed
these questions before.

1 -  I am trying to execute the following set of commands:

BEGIN WORK;
  INSERT INTO TBL VALUES (1,1);
  SAVEPOINT SVPT;
  INSERT INTO TBL VALUES (1,1); /*GENERATES ERROR */
  ROLLBACK TO SAVEPOINT SVPT;
COMMIT;

When I execute this postgre returns an error in the insertion from as
register and driver is generating a ROLLBACK automatically for this
reason.  With this the SAVEPOINT does not function therefore the
transaction already was cancelled.  It would be interesting if driver
did not execute this ROLLBACK automatically, leaving that I decide
what to make.

2 -  With disponibilizado driver currently in the page for download,
together with version 8.0.3 of postgre, when I execute one select to
return one or more columns of the type to varchar they do not return.
I am using type SQL_ASCII.  The configurations of locale are ' C '.
What it can be?

Debtor.

pgsql-odbc by date:

Previous
From: Håkon Clausen
Date:
Subject: Re: ODBC driver types
Next
From: "Dave Page"
Date:
Subject: Re: ODBC driver types