Skip site navigation (1) Skip section navigation (2)

linked tables Access <---> PG 7.4.1

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: linked tables Access <---> PG 7.4.1
Date: 2004-01-16 00:27:21
Message-ID: 40072FE9.5090608@gmx.net (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,
I fear this might be off-topic but I'm sure I'd be hit, too, if I asked 
something concerning the interaction with PostgreSQL on  the dark side.   ;)

Client:   MS-Access 2000
Server:  PG 7.4.1

I ODBC-link some tables and all is fine.
Then I manually link a PostgreSQL-view and Access asks which of the 
fields will be the primary key of this "table".

Then again, if I link the view with VBA's DAO command  
CurrentDB.CreateTableDef( [...] ) no question appears and the view gets 
created as a table-object.
If I inspect it's design, there is no field marked as primary key.

Is the PK really obsolete or does it have implications in the 
performance of Access or PG ?


Thanks
Andreas




Responses

pgsql-odbc by date

Next:From: CHENDate: 2004-01-16 01:40:17
Subject: psqlodbc crash VFP
Previous:From: Philippe LangDate: 2004-01-15 16:13:28
Subject: Re: No Current Record

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group