search

OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)
https://ohdsi.github.io/CommonDataModel
877 stars 448 forks source link

Death table removed, but index added in OMOP CDM postgresql pk indexes.txt #228

Closed ronaldcornet closed 3 years ago

ronaldcornet commented 5 years ago

In v6.0, table "death" is removed. However, in "OMOP CDM postgresql pk indexes.txt" an index is added to this now non-existing table.

Fix: remove these lines: 104, 256,257: ALTER TABLE death ADD CONSTRAINT xpk_death PRIMARY KEY ( person_id ) ; CREATE INDEX idx_death_person_id ON death (person_id ASC); CLUSTER death USING idx_death_person_id ;

clairblacketer commented 5 years ago

thanks for letting me know!

pemaro commented 3 years ago

In v6.0, table "death" is removed. However, in "OMOP CDM postgresql pk indexes.txt" an index is added to this now non-existing table.

I have the same issue in "OMOP CDM sql server pk indexes' file in line 245. Is this solve?

Thanks in advance

clairblacketer commented 3 years ago

Hi, sorry this hasn't been solved yet. We are in the process of overhauling the repository to make it easier for collaboration from the community.

clairblacketer commented 3 years ago

closing this as it is a historical issue that is fixed by the new R package