Re: Problems with PsqlOdbc.

> -----Original Message-----
> From: Cleber Nardelli [mailto:clebernardelli(at)gmail(dot)com]
> Sent: 29 September 2005 00:15
> To: Dave Page
> Cc: pgsql-odbc(at)postgresql(dot)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