Re: [INTERFACES] another ODBC/Access question..

Tim Bosinius wrote:

> When connecting Access97 to a postgreSQL datasource with ODBC
> the pg_attribute.attnuotnull is not queried and therefore not set
> in Access.
>

Currently, the driver just returns "everything is nullable".   It used to vary
based on datatypes, but since most datatypes can handle nulls, that wasn't
very good.

I think it would make a good addition to the driver to handle nulls based on
the column attribute as you suggest.  For Access, which uses SQLColumns to
determine this fact, this will work great.  However, other applications that
use SQLDescribeCol or SQLColAttributes will still get only the datatype
nullability since there really is no easy way to get this kind of information
given only a result set from the backend.

I will add this in the next release.

Byron