From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
---|---|
To: | Denis Gasparin <denis(at)edinet(dot)it> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Primary keys and ODBC/Microsoft Access |
Date: | 2001-09-10 10:45:06 |
Message-ID: | Pine.LNX.4.21.0109101244350.28746-100000@nanu.visionforisrael.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
yes, look in the driver settings... :) IIRC, there's an option to
"recognize unique indexes". You should probably read
-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(at)edistar(dot)com
> ---------------------------
> Programmer & System Administrator - Edistar srl
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
From | Date | Subject | |
---|---|---|---|
Next Message | Manfred Kraft | 2001-09-10 14:54:45 | 'ODBC call failed' a few seconds after Opening the table in Access |
Previous Message | Denis Gasparin | 2001-09-10 08:10:01 | Primary keys and ODBC/Microsoft Access |