Postgres Pro
Downloads
Home   >   mailing lists

Thread: ODBC changes

ODBC changes

From
Hiroshi Inoue
Date:
Hi all,
I commited the following change.

1) Change transaction boundary in autocommit off mode
   per recent discussion in pgsql-odbc. Now SELECT is
   a boundary but VACUUM isn't.
2) Put back the error handling behavior. When elog(ERROR)
   was detected the driver automatically issues "ABORT"
   if a transaction is in progress.
3) Driver version is 7.01.0003(Dave already set it but
   it was put back to 7.01.0002 sorry).

Regards,
Hiroshi Inoue

RE: ODBC changes

From
Dave Page
Date:

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> Sent: 15 February 2001 07:10
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC changes
>
>
> Hi all,
> I commited the following change.
>
> 1) Change transaction boundary in autocommit off mode
>    per recent discussion in pgsql-odbc. Now SELECT is
>    a boundary but VACUUM isn't.
> 2) Put back the error handling behavior. When elog(ERROR)
>    was detected the driver automatically issues "ABORT"
>    if a transaction is in progress.
> 3) Driver version is 7.01.0003(Dave already set it but
>    it was put back to 7.01.0002 sorry).

If no one else is going to make any mods for the next couple of days I'll
compile a new win32 binary for people to try out. If I don't hear anything
by tomorrow morning (UK time) I'll go ahead and create one...

Regards,

Dave.

Re: ODBC changes

From
Hiroshi Inoue
Date:
Dave Page wrote:
>
> If no one else is going to make any mods for the next couple of days I'll
> compile a new win32 binary for people to try out. If I don't hear anything
> by tomorrow morning (UK time) I'll go ahead and create one...
>

I'm implementing one more change(automatic casting for
numeric type). If an expert confirms the validity I
would commit it in a day or so.

Regards,
Hiroshi Inoue

Re: ODBC changes(Please check)

From
Hiroshi Inoue
Date:
I wrote:
>
> Dave Page wrote:
> >
> > If no one else is going to make any mods for the next couple of days I'll
> > compile a new win32 binary for people to try out. If I don't hear anything
> > by tomorrow morning (UK time) I'll go ahead and create one...
> >
>
> I'm implementing one more change(automatic casting for
> numeric type). If an expert confirms the validity I
> would commit it in a day or so.
>

I've just committed the following change.
Please check the change especially in unixODBC.

 Add casting for numeric/float4/float8 type value
 automatically to compensate the lack of automatic
 conversion functionality of PostgreSQL server.
 For example if there's a numeric type binding
   1.2567 --> 1.2567::numeric.
 I hope this change would enable the use of numeric
 type in MS-Access etc.

Thanks Hiroki Kataoka for his checking my code.

Regards,
Hiroshi Inoue