[INTERFACES] MSAccess and primary keys

From: leif(at)danmos(dot)dk
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: [INTERFACES] MSAccess and primary keys
Date: 1999-05-15 08:34:45
Message-ID: 199905150834.KAA28939@crysberg.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


[Sorry for reposting this, the subject got garbled.]

Hello,

I have a rather anoying problem. I am linking a quite large
M$Access application to a PostgreSQL database with a a lot of
relations (primary keys/foreign keys). In all my tables I have
created primary keys (to keep M$Access happy ;-). Unfortunately,
when I link my application to the database, Access asks me for
each and every table (there are more than 80 of them) what I
want to use for unique index field. I thought the primary key
spec would do just that?

All tables are designed like the one below:

create table globalafvigelse
(
id serial ,
startdato date,
slutdato date,
dagskema varchar(50),
primary key (globalafvigelse)
);

Greetings,

Leif
(leif(at)danmos(dot)dk)

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 1999-05-15 09:12:03 Re: [HACKERS] 6.5 cvs: problem with includes in src/interfaces/libpq++/
Previous Message leif 1999-05-15 08:31:47 [INTERFACES] M and primary keys