Hi list !
I created a view in postgresql (quite complex, multiple tables are
linked). The aim is to link it in acces via ODBC.
In needed to auto-number the rows, and I created a sequence for that
(thanks to a good advice on the GENERAL list).
In Access, I know that I need good primary keys on my linked tables
(integer, single column). I though that using this column as a primary
key would be a good idea .
The view looks like this :
CREATE OR REPLACE VIEW my_view AS
SELECT nextval('my_view_seq'::regclass)::integer AS "index", <many
other fields> FROM <many tables>;
Note I had to explicitely cast the sequence as integer, because it was
detected as a decimal field in Access (equivalent to NUMERIC in
PostgreSQL).
In Access I link my tables via some VBA code. I have a routine that
creates the primary keys when they are non-trivial. In this case, the
routine executes "CREATE UNIQUE INDEX my_pkey ON TABLE my_linked_table
(index)".
The primary key is created OK, the column is recognized as
integer-type in Access, but when I open the table all the fields are
marked as #DELETED.
Where exactly is the problem here ?
Is it just impossible to use this sequence-generated field as a
primary key in Access ?
Thanks for your help on this !
--
Arnaud