Re: ODBC v08.02.0100

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

luiz wrote:
> Hi all,
>
> I make some tests with this new version and i notice a diference in the
> behaviour about the structures of tables returned by queries trough  this
> version and older versions of odbc
>
> I'm using Visual FoxPro with postgres 8.1.4.
>
> In previous version all fields are marked to accept null values.
>   

Yes the driver didn't check the nullabilties at all.

> In this version (8.02.0100) some fields now don't accept null values, seemed
> to me that now use the same definition of source table structure, like this:
>
> CREATE TABLE test (
>   id serial NOT NULL,
>   fk_test2 int4,
>   field1 char(3) NOT NULL,
>   field2 varchar(10),
>   field3 date );
>
> CREATE TABLE test2 (
>   id serial NOT NULL,
>   field4 char(3) NOT NULL,
>   field5 char(3) );
>
> SELECT test.* 
>      , test2.id as id2 
>      , test2.field4 
>      , test2.field5
>   from test LEFT OUTER JOIN test2 on test.fk_test2 = test2.id;
>   

Oops outer join. It's not easy to correct it unfortunately.
It's hard for the driver to kow the structure of queries because the 
driver doesn't analyze queries fundamentally.

regards,
Hiroshi Inoue