Re: Problems with PsqlOdbc. - Mailing list pgsql-odbc

From Dave Page
Subject Re: Problems with PsqlOdbc.
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC2FA4@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Problems with PsqlOdbc.  (Cleber Nardelli <clebernardelli@gmail.com>)
List pgsql-odbc

> -----Original Message-----
> From: Cleber Nardelli [mailto:clebernardelli@gmail.com]
> Sent: 29 September 2005 00:15
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Problems with PsqlOdbc.
>
> 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.

Works perfectly for me with the latest driver. You should note though
that savepoint support is not complete yet - Hiroshi Saito is working on
it.

> 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?

What does disponibilizado mean? Anyway, It sounds like classic symptoms
of using the Unicode driver with a Borland/BDE based application. If so,
switch to the ANSI driver and you should be OK.

Regards, Dave

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: ODBC driver types
Next
From: "Thomas Knoop"
Date:
Subject: Re: PostgreSQL / ODBC / Ms-SQL 2000