MS Access & psqlODBC : Primary Key issue
От | Arnaud Lesauvage |
---|---|
Тема | MS Access & psqlODBC : Primary Key issue |
Дата | |
Msg-id | 445875FB.7010701@freesurf.fr обсуждение исходный текст |
Список | pgsql-odbc |
Hi List ! I am trying to st up MS Access (2000) as a frontend for PostgreSQL (8.1.2) using psqlODBC (8.01.0200). There used to be a web site on this subject, but www.scw.org seems to be offline. There seems to be a problem with Access not recognizing my primary keys. It works for some tables, but not for others. My ODBC data source is configured as this : Checked : Disable Genetic Optimizer KSQO Recognize Unique Indexes Parse Statements Unknown Size Maximum Text as LongVarChar LF <-> CR/LF conversion Row Versionning True is -1 Int8 As Default The problematic table is : CREATE TABLE geo_pays ( gid int4 NOT NULL DEFAULT nextval('geo_pays_gid_seq'::regclass), codecontinent int8, codepays int8 NOT NULL, payspopulation int8, payscapitale varchar(100), payssuperficie varchar(50), paysdensite varchar(50), payspib varchar(50), CONSTRAINT geo_pays_pkey PRIMARY KEY (codepays), CONSTRAINT geo_pays_continents_fkey FOREIGN KEY (codecontinent) REFERENCES geo_continents (codecontinent) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION ) WITHOUT OIDS; In MSAccess, I link the table without any problem. Access does not ask me for a unique row identifier (it does for some other tables, but not for this one), *but* the primary key that it automatically detects is payspopulation !!! There isn't even an index on this column ! What is the problem with my configuration ? Thanks for your help ! Regards -- Arnaud
В списке pgsql-odbc по дате отправления: