Re: Confusion

Hiroshi Inoue wrote:
>
> Igor Kovalenko wrote:
> >
> > Hello list,
> >
> > Can someone please fill me up on the state of affairs with ODBC support?
> > I tried to search docs and FAQs but it is confusing as hell.
> >
> > I need to understand relation between unixODBC per say and
> > --with-unixODBC option.
>
> This(--with-unixODBC) option was added in PostgreSQL
> recently and you can produce the driver for unixODBC.
> OTOH unixODBC has provided its own odbcpsql driver
> because PostgreSQL didn't provide the driver for unixODBC
> until recently. Probably the 2 drivers are pretty different
> each other currently.

Does the driver supplied with postgres depend on something else? I do
not see any dependencies in the library other than standard system libs.
Is that normal or my build is broken?

It also appears to be impossible to build PHP without installing
unixODBC, due to missing headers. Postgres comes only with headers for
iODBC (isql.h, isqlext.h, iodbc), but NOT for unixODBC (sql.h, sqlext.h,
odbc.h). I need to use unixODBC because there's no iDOBC binaries for my
platform and I did not find source either.

>
> > The latter seem to produce libpsqlodbc.so,
>
> Really ? It would produce libodbcpsql.so.

Not for me. --with-unixODBC produces libpsqlodbc.so in my case.

- igor