ODBC v08.02.0100 - Mailing list pgsql-odbc

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.
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;

The fields of resultset will be now this:

id int4 NOT NULL
fk_test2 int4
field1 char(3) NOT NULL
field2 varchar(10)
field3 date
id2 int4 NOT NULL
field4 char(3) NOT NULL
field5 char(3)

with odbc version 8.01.0200 all fields accept null values.

I'm not sure about what is the correct behaviour, but this can be considered
as a bug in the new version ?

Thanks in Advance

Luiz