From: "Joel Burton" <jburton@scw.org>
Organization: Support Center of Washington
To: "Emmanuel Charpentier,,," <charpent@bacbuc.dyndns.org>
Date: Mon, 18 Dec 2000 17:03:29 -0500
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: Coppatibility of ODBC drivers with forecoming 7.1
CC: Pgsql-interfaces@postgresql.org
Message-ID: <3A3E4361.1689.94149@localhost>
In-reply-to: <3A3B27D0.1090008@bacbuc.dyndns.org>

On 16 Dec 2000, at 9:29, Emmanuel Charpentier,,, wrote:

> It seems that PosgreSQL 7.1, which is in beta and seems to be close
> the out door, will bring us, among other things, the much awaited
> outer joins.
> 
> I wonder if a new ODBC driver will be necessary to be able to use this
> feature, or if the current (6.50.0, IIRC) will be able to use it more
> or less "automagically".

I've been using 7.1devel for a few months w/ODBC (mostly Access, 
some VB), and it works fine for outer joins.

It does not however work well with the stock ODBC driver, which 
shows no tables. You should compile the driver from CVS sources. 
(This also fixes the referential-integrity-error problem).

More information & a precompiled driver at www.scw.org/pgaccess
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)