Re: Primary keys and ODBC/Microsoft Access

yes, look in the driver settings... :)  IIRC, there's an option to
"recognize unique indexes".  You should probably read

  http://www.scw.org/pgaccess

-Cedar

On Mon, 10 Sep 2001, Denis Gasparin wrote:

>
> Hi to all!
>          I use the Postgresql ODBC driver (ver. 7.01.00.05) with Microsoft
> Access. When i try to open a connection to a postgresql database, Access
> gives me a list of the database tables and then, after I have selected all
> the tables I need, it asks me to indicate the primary key of each table...
> Such a thing didn't happen with any database server I used before (Solid or
> MySQL for example...) and obviosly I don't remember all the primary keys of
> a 30 tables database...
>          Is there anything I have to set in the Postgresql driver (or in
> the postgresql backend) to change this behaviour?
>
> Thanks in advance...
>
> Eng. Denis Gasparin: denis@edistar.com
> ---------------------------
> Programmer & System Administrator - Edistar srl
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>