Re: Patch for ODBC driver (look for odbc.ini in more than one - Mailing list pgsql-patches

From Hiroshi Inoue
Subject Re: Patch for ODBC driver (look for odbc.ini in more than one
Date
Msg-id 3C15DB47.7C18FF34@tpf.co.jp
Whole thread Raw
In response to Patch for ODBC driver (look for odbc.ini in more than one location)  ("Ross Thomas" <ross@grinfinity.com>)
List pgsql-patches
Ross Thomas wrote:
>
> Since most ODBC drivers and driver managers look for odbc.ini in several
> locations on UNIX systems, it would seem sensible to have the PostgreSQL
> driver do the same thing. (This idea occurred to me after five hours of
> trying to figure out what libpsqlodbc didn't like about my /etc/odbc.ini,
> but that's another story.)
>
> iODBC, for example, does the following:
>
> 1) Checks $ODBCINI
> 2) Checks $HOME/.odbc.ini
> 3) Checks ~/.odbc.ini (where ~ is obtained from struct passwd)
> 4) Checks system-wide odbc.ini (in /etc by default)

IIRC iODBC 3.0.5 has iodbcinst library which knows
where to write/get the profile values.
PostgreSQL 7.2 provides a configure option --with-iodbc
with which PostgreSQL doesn't use gpps.c at all but links
with the installed odbcinst library.

regards,
Hiroshi Inoue

pgsql-patches by date:

Previous
From: "Serguei Mokhov"
Date:
Subject: Re: hu.po
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] date formatting and tab-complete patch